Question

以下声明将回复开放Query(MYSQL)的数值。

Select * From OpenQuery(MYSQL,  Select * From ResearchRpt ) a
Where Not Exists (Select * From dbo.ResearchRpt where Id_report = a.Id_report)

我希望在结果价值应当 d落的地方扭转这一局面。研究

感谢。

Answer 1

你的问询使用了反jo。可通过<代码>实施反职业守则。 LEFT JOIN +WHE ISNUL 以及<代码> NOT EXISTS 因此,将你的文字转换为LEFT JOIN版本,向双方倾斜。

SELECT ms.*
FROM dbo.ResearchRpt ms
  LEFT JOIN OPENQUERY(MYSQL,  SELECT * FROM ResearchRpt ) my
    ON my.Id_report = ms.Id_report
WHERE my.Id_report IS NULL

Answer 2

-- Only exists

SELECT ms.*, my.Id_report
FROM dbo.ResearchRpt ms
LEFT JOIN OPENQUERY(MYSQL,  SELECT * FROM ResearchRpt ) my
ON my.Id_report = ms.Id_report
WHERE my.Id_report IS NOT NULL

友情链接