如何进行多表左外连接

有一主表，需要和多个子表连接，怎么写语句  
  主表A  
  子表B，C，D  
  select   A.COLA,B.COLB,C.COLC.D.COLD  
  from   A   left   outer   join   B,C,D  
  on   A.COLB=B.COLB   AND   A.COLC=C.COLC   AND   A.COLD=C.COLD  
  对吗？ 问题点数：20、回复次数：4Top

1 楼OpenVMS（半知半解）回复于 2002-05-08 13:25:30 得分 10

select   A.COLA,B.COLB,C.COLC.D.COLD  
  from   A  
  left   outer   join   B   on   A.COLA=B.COLB  
  left   outer   join   C   on   A.COLA=C.COLB  
  left   outer   join   D   on   A.COLA=D.COLB  
  Top

2 楼OpenVMS（半知半解）回复于 2002-05-08 13:26:36 得分 0

select   A.COLA,B.COLB,C.COLC.D.COLD  
  from   A  
  left   outer   join   B   on   A.COLA=B.COLB  
  left   outer   join   C   on   A.COLA=C.COLC  
  left   outer   join   D   on   A.COLA=D.COLD  
   
  Top

3 楼OpenVMS（半知半解）回复于 2002-05-08 13:28:01 得分 0

select   A.COLA,B.COLB,C.COLC.D.COLD  
  from   A  
  left   outer   join   B   on   A.COLA=B.COLB  
  left   outer   join   C   on   A.COLA=C.COLC  
  left   outer   join   D   on   A.COLA=D.COLD  
   
  Top

4 楼Yang_（扬帆破浪）回复于 2002-05-08 13:28:09 得分 10

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  
  Top

5 楼Yang_（扬帆破浪）回复于 2002-05-08 13:29:44 得分 0

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=D.COLD  
  Top

相关问题

• cola
• colb
• colc
• coldfrom
• outer join
• colbleft
• coldselect
• cold
• aleft
• left

• 帖主：mozhou
• OpenVMS
• Yang_

• SQL Server类图书