用子查询先过滤,再连接。 还有要 3 个连接关系。 SELECT * FROM (SELECT * FROM lh_zt WHERE lh_zt.DATE = CONVERT(VARCHAR(10),Getdate() - 1,120) ) lh_zt FULL JOIN (SELECT * FROM lh_xz WHERE lh_xz.DATE = CONVERT(VARCHAR(10),Getdate() - 1,120) ) lh_xz ON lh_zt.DATE = lh_xz.DATE FULL JOIN (SELECT * FROM lh_dg WHERE lh_dg.DATE = CONVERT(VARCHAR(10),Getdate() - 1,120) ) lh_dg ON lh_zt.DATE = lh_dg.DATE OR lh_xz.DATE = lh_dg.DATE
还有要 3 个连接关系。
SELECT *
FROM (SELECT * FROM lh_zt WHERE lh_zt.DATE = CONVERT(VARCHAR(10),Getdate() - 1,120)
) lh_zt
FULL JOIN (SELECT * FROM lh_xz WHERE lh_xz.DATE = CONVERT(VARCHAR(10),Getdate() - 1,120)
) lh_xz
ON lh_zt.DATE = lh_xz.DATE
FULL JOIN (SELECT * FROM lh_dg WHERE lh_dg.DATE = CONVERT(VARCHAR(10),Getdate() - 1,120)
) lh_dg
ON lh_zt.DATE = lh_dg.DATE
OR lh_xz.DATE = lh_dg.DATE