17,140
社区成员




SELECT T21.COL1,T21.COL2,T31.COL2 FROM (SELECT T2.COL1,T2.COL2 FROM T1,T2 WHERE T1.COL1=T2.COL1) T21
FULL OUTER JOIN (SELECT T3.COL1,T3.COL2 FROM T1,T3 WHERE T1.COL1=T3.COL1) T31 ON T21.COL1=T31.COL1
SELECT T2.COL1,T2.COL2,T3.COL2 FROM (SELECT T2.COL1,T2.COL2 FROM T1,T2 WHERE T1.COL1=T2.COL1) T21
FULL OUTER JOIN (SELECT T3.COL1,T3.COL2 FROM T1,T3 WHERE T1.COL1=T3.COL1) T31 ON T21.COL1=T31.COL1