3,490
社区成员
发帖
与我相关
我的任务
分享
FROM tab_a a JOIN tab_b b ON a.id=b.id LEFT JOIN tab_c c ON b.id=c.id AND b.time=c.time JOIN tab_d d ON ....
select * from tab_b b LEFT JOIN tab_c ON b.id=c.id AND b.time = c.time
SELECT *
FROM (SELECT *
FROM tab_a a, tab_b b
WHERE a.ID = b.ID) aa,
(SELECT *
FROM tab_c c, tab_d d, tab_e e
WHERE c.ID) bb
WHERE aa.ID = bb.ID(+) AND aa.TIME = bb.TIME(+)