基表A,与多个表连接。SQL如下:
select A.COLA,B.COLB,C.COLC,D.COLD
from A left outer join B
on A.COLB=B.COLB
left outer join C
on A.COLC=C.COLC
left outer join D
A.COLD=C.COLD
基表A,与多个表连接。SQL如下:
select A.COLA,B.COLB,C.COLC,D.COLD
from A left outer join B
on A.COLB=B.COLB
left outer join C
on A.COLC=C.COLC
left outer join D
A.COLD=C.COLD