SQL查询删除与两个不同数据库内部联接的3个表中的重复值

SQL查询删除与两个不同数据库内部联接的3个表中的重复值

我想通了，这要归功于group
by子句不能与Image一起工作，
我所要做的就是像这样通过将其CASTING到VARBINARY来添加更改图像列的文字：

SELECt     "AM-Martin".dbo.CpCore_Site.Number,"AM-Martin".dbo.CpCore_Site.Latitude,"AM-Martin".dbo.CpCore_Site.Longitude,"AM-Martin".dbo.CpSm_Face.RetiredOn,**CAST("AM-Martin_bin".dbo.CpCore_Image.Bytes as Varbinary)**, "AM-Martin".dbo.CpCore_Site.Name, "AM-Martin".dbo.CpCore_Site.ZippreFROM    "AM-Martin".dbo.CpCore_SiteINNER JOIN "AM-Martin".dbo.CpSm_Face on "AM-Martin".dbo.CpSm_Face.SiteId = "AM-Martin".dbo.CpCore_Site.OidINNER JOIN "AM-Martin_bin".dbo.CpCore_Image on "AM-Martin".dbo.CpSm_Face.Oid = "AM-Martin_bin".dbo.CpCore_Image.OwnerIdWHERe    "AM-Martin".dbo.CpSm_Face.RetiredOn LIKE '%9999%'     AND "AM-Martin".dbo.CpCore_Site.Number LIKE N'%LA%' OR "AM-Martin".dbo.CpCore_Site.Number LIKE N'%LC%' OR "AM-Martin".dbo.CpCore_Site.Number LIKE N'%BH%'     AND "AM-Martin".dbo.CpCore_Site.Latitude > 0.0GROUP BY "AM-Martin".dbo.CpCore_Site.Number,"AM-Martin".dbo.CpCore_Site.Latitude,"AM-Martin".dbo.CpCore_Site.Longitude,"AM-Martin".dbo.CpSm_Face.RetiredOn,**CAST("AM-Martin_bin".dbo.CpCore_Image.Bytes as Varbinary)**, "AM-Martin".dbo.CpCore_Site.Name, "AM-Martin".dbo.CpCore_Site.Zippre;

我也必须赞扬@Myonara，以帮助我在小组的建议下走上正确的道路。