27,579
社区成员
发帖
与我相关
我的任务
分享
CREATE INDEX index_tbA_A ON tbA(AA,BB,CC,DD)
CREATE INDEX index_tbB_B ON tbB(AA,BB,CC,DD)
CREATE INDEX index_tbC_C ON tbC(AA,BB,CC,DD)
SELECT *
FROM tbA a
LEFT JOIN tbB b ON a.AA = b.Aa
AND a.BB = b.BB
AND a.CC = b.CC
AND a.DD = b.DD
AND b.AA IS NOT NULL
LEFT JOIN tbC c ON a.AA = c.AA
AND a.BB = c.BB
AND a.CC = c.CC
AND a.DD = c.DD
AND c.AA IS NULL