使用表的Join方法:SELECT T1.COL1,T1.COL2,T1.COL3,T2.COL4,T2.COL5 FROM T1,T2 或者 SELECT T1.COL1,T1.COL2,T1.COL3,T2.COL4,T2.COL5 FROM T1 JOIN T2更加整齐一点的,可以这样写:SELECT T1.COL1,T1.COL2,T1.COL3,T2.COL4,T2.COL5 FROM T1 JION T2 ON T1.COL1 =T2.COL1试试看吧!!
select a.col1,a.col2,a.col3,b.col4,b.col5 from t1 a left join t2 b on col1 Union select * from t2
select a.col1,a.col2,a.col3,b.col4,b.col5 from t1 a left join t2 b on a.col1 = b.col1 Union select * from t2
DBMS(數據庫)是什麼? 不同的數據庫寫法不同.
select t1.col1,t1.col2,t1.col3,t2.col4,t2.col5 from t1,t2 where t1.col1=t2.col1(*)
這是SQLServer的寫法:(select isnull(t1.col1,t2.col1) col1,isnull(col2,0) col2,isnull(col3,0) col3,isnull(col4,0) col4,isnull(col5,0) col5 from t1 left join t2 on(t1.col1 = t2.col1 ) ) union (select isnull(t2.col1,t1.col1),isnull(col2,0),isnull(col3,0),isnull(col4,0),isnull(col5,0) from t2 left join t1 on(t2.col1 = t1.col1 ) ) order by col1;在SQLServer7.0的Query Analyzer中通過並取得了你要的結果.如果你的DBMS是Oracle請說一聲,我是數據庫開發版的. 竹之草
oracle中: select a.col1,a.col2,a.col3,nvl(b.col4,0),nvl(b.col5,0) from T1 a,T2 b where a.col1 = b.col2(+) union select b.col1,nvl(a.col2,0),nvl(a.col3,0),b.col4,b.col5 from T1 a,T2 b where a.col1(+) = b.col2;
select a.col1,a.col2,a.col3,b.col4,b.col5 from t1 a left join t2 b on col1 Union select * from t2
to wangyhao(亦豪),qiandeng(千灯): 看來你們不理解union的含義. 你們這樣的SQL語句如果不報錯. 我這輩子算白玩數據庫了.列數不一樣怎麼可能union到一起去?!
或者
SELECT T1.COL1,T1.COL2,T1.COL3,T2.COL4,T2.COL5 FROM T1 JOIN T2更加整齐一点的,可以这样写:SELECT T1.COL1,T1.COL2,T1.COL3,T2.COL4,T2.COL5 FROM T1 JION T2
ON T1.COL1 =T2.COL1试试看吧!!
Union select * from t2
不同的數據庫寫法不同.
from t1,t2
where t1.col1=t2.col1(*)
from t1 left join t2 on(t1.col1 = t2.col1 ) ) union
(select isnull(t2.col1,t1.col1),isnull(col2,0),isnull(col3,0),isnull(col4,0),isnull(col5,0)
from t2 left join t1 on(t2.col1 = t1.col1 ) ) order by col1;在SQLServer7.0的Query Analyzer中通過並取得了你要的結果.如果你的DBMS是Oracle請說一聲,我是數據庫開發版的. 竹之草
select a.col1,a.col2,a.col3,nvl(b.col4,0),nvl(b.col5,0)
from T1 a,T2 b where a.col1 = b.col2(+)
union
select b.col1,nvl(a.col2,0),nvl(a.col3,0),b.col4,b.col5
from T1 a,T2 b where a.col1(+) = b.col2;
Union select * from t2
看來你們不理解union的含義.
你們這樣的SQL語句如果不報錯.
我這輩子算白玩數據庫了.列數不一樣怎麼可能union到一起去?!