表1:
ter_id fielda
1 34
2 45
3 56
表2:
ter_id fieldb
3 a
4 b
5 c
合并为表3:
ter_id fielda filedb
1 34
2 45
3 56 a
4 b
5 c
请问表1和表2能不能直接合并成表3
能不能用一条SQL语句执行?
谢谢!
ter_id fielda
1 34
2 45
3 56
表2:
ter_id fieldb
3 a
4 b
5 c
合并为表3:
ter_id fielda filedb
1 34
2 45
3 56 a
4 b
5 c
请问表1和表2能不能直接合并成表3
能不能用一条SQL语句执行?
谢谢!
解决方案 »
- cxgrid 小数显示为百分比模式 pivotgrid 分类小记不同颜色显示
- 原则性散分~~~~~~~~~
- 窗体不能最大化了,最上面有一点空隙
- 如何用中文显示?
- adoconnectstring的问题
- visibroker4.x下载地址!!
- 哪位高手告诉我如何做一个delphi数据库应用程序来操作sqlserver2000的数据库?
- 我想在ShowMessage('提示信息');后出现一声响声,提示用户,怎么样做?
- 关于WWDBGRID、WWTABLE、QUERY的问题。请问如何在WWTABLE中使用QUERY,同时实现在WWDBGRID中修改数据。
- 如何使TPanel和TPageControl上的控件也能用“Enter”键改变焦点?
- 限制输入登录密码三次为什么无效?
- 急啊急!贴子挂了一星期没人回答,不能提前了,请高手进来看看。
from table1 a
full outer join table2 b
on a.ter_id = b.ter_id
on T1.ter_id=T2.tre_id
T1.ter_id1=T2.tre_id1 and T1.ter_id2=T2.tre_id2 and T1.ter_id3=T2.tre_id3
and T1.ter_id1=T3.tre_id1 and T3.ter_id2=T3.tre_id2 and T1.ter_id3=T3.tre_id3
and T1.ter_id1=T4.tre_id1 and T1.ter_id2=T4.tre_id2 and T1.ter_id4=T4.tre_id3
and T2.ter_id1=T3.tre_id1 and T2.ter_id2=T3.tre_id2 and T2.ter_id3=T3.tre_id3
and T2.ter_id1=T4.tre_id1 and T2.ter_id2=T4.tre_id2 and T2.ter_id4=T4.tre_id3
and T3.ter_id1=T4.tre_id1 and T3.ter_id2=T4.tre_id2 and T3.ter_id4=T4.tre_id3
T1.ter_id1=T2.tre_id1 and T1.ter_id2=T2.ter_id2 and T1.ter_id3=T2.ter_id3
and T1.ter_id1=T3.tre_id1 and T3.ter_id2=T3.ter_id2 and T1.ter_id3=T3.ter_id3
and T1.ter_id1=T4.tre_id1 and T1.ter_id2=T4.ter_id2 and T1.ter_id4=T4.ter_id3
and T2.ter_id1=T3.tre_id1 and T2.ter_id2=T3.ter_id2 and T2.ter_id3=T3.ter_id3
and T2.ter_id1=T4.tre_id1 and T2.ter_id2=T4.ter_id2 and T2.ter_id4=T4.ter_id3
and T3.ter_id1=T4.tre_id1 and T3.ter_id2=T4.ter_id2 and T3.ter_id4=T4.ter_id3
select a.ter_id, 表1.fielda, 表2.filedb
from
(select ter_id from 表1
union select ter_id from 表2) a,表1, 表2
where a.ter_id *=表2.ter_id
and a.ter_id *=表1.terid
调试已通过
select * from 表1 uinon select * from 表2
form 1
union
select ter_id,('null') as fielda,fieldb,('null') as fieldc...
from 2
.
.
.
不一样 out union
union all
select a.ter_id,a.fielda,'' from a where ter_id not in (select ter_id from b)
union all
select b.ter_id,'',b.fieldb from b where ter_id not in (select ter_id from a)
order by a.ter_id
注:表1=a 表2=b