求救...

[wwwiii520]

tableA和tableB
Colid   ColB   ColC |Colid   ColD   ColJ
1        B       C  | 5        S      P
2        S       Q  | 1        W      M
3        M       D  | 4        E      L

查詢出一個表
Colid ColB ColC ColD ColJ
1 B C W M
2 S Q
3 M D
4 E L
5 S P

[jinjazz]

select 
isnull(a.Colid,b.Colid) Colid,
ColB,  ColC,  ColD , ColJ 
 from a full outer join b
on a.Colid=b.Colid

[jinjazz]

select 
isnull(a.Colid,b.Colid) Colid,
ColB,  ColC,  ColD , ColJ 
 from a full outer join b
on a.Colid=b.Colid

[Andy__Huang]

乌龟不见来,这个题好占分...

[ws_hgo]

select isnull(a.Colid,b.Colid) Colid,isnull(ColB,null),isnull(ColC,null),isnull(ColD,null),isnull(ColJ,null) from a full join b
on a.Colid=b.Colid

[ws_hgo]

注意结贴速度

[ks_reny]

用全连接。

select 
isnull(a.Colid,b.Colid) Colid,
ColB,  ColC,  ColD , ColJ 
 from a full outer join b
on a.Colid=b.Colid

[jinjazz]

isnull(ColC,null)

这有意义?

[ws_hgo]

[Quote=引用 7 楼 jinjazz 的回复:]
isnull(ColC,null)

这有意义?
[/Quote]
噢
错啦

select isnull(a.Colid,b.Colid) Colid,ColB,ColC,ColD,ColJ, from a full join b
on a.Colid=b.Colid

谢啦

[htl258_Tony]

select isnull(a.Colid,b.Colid) Colid,isnull(ColB,'') ColB,isnull(ColC,'') ColC,isnull(ColD,'') ColD,isnull(ColJ,'') ColJ, from a full join b
on a.Colid=b.Colid

[ai_li7758521]

select
isnull(a.Colid,b.Colid) Colid,isnull(ColB,''),isnull(ColC,''),isnull(ColD,''),isnull(ColJ,'') from a full join b
on a.Colid=b.Colid

[claro]

帮顶

[wwwiii520]

a full join b on a.Colid=b.Colid

單用全連接查詢不行的. Colid沒有總合成一個列.

[yuyangyangde]

[Quote=引用 3 楼 hdhai9451 的回复:]
乌龟不见来,这个题好占分...
[/Quote]
...

[ljluck7687]

不错，是个全连接问题，可用关键字full outer join来全连接两个表

也可以这样写
select a.Colid,a.ColB,a.ColC,b.ColD,b.ColJ from a,b where a.id*=b.id

[htl258_Tony]

select * into table1 from (
select 1   Colid ,     'B'  ColB ,     'C'  ColC
union all select 2    ,    'S'  ,     'Q'  
union all select 3    ,    'M'   ,    'D'  
) t
select * into table2 from (
select 5   Colid ,     'S'  ColD ,     'P'  ColJ
union all select 1    ,    'W'  ,     'M'  
union all select 4    ,    'E'   ,    'L'  
) t

select isnull(a.Colid,b.Colid) Colid,isnull(a.ColB,'') ColB,isnull(a.ColC,'') ColC,isnull(b.ColD,'') ColD,isnull(b.ColJ,'') ColJ from table1 a full join table2 b
on a.Colid=b.Colid
order by colid

drop table table1,table2

Colid       ColB ColC ColD ColJ 
----------- ---- ---- ---- ---- 
1           B    C    W    M
2           S    Q         
3           M    D         
4                     E    L
5                     S    P

（所影响的行数为 5 行）

[zjl8518]

isnull 函数真好用啊！

[牙签是竹子的]