求一SQL语句

[waslee]

有两个表 A,B
A表
name pwd id
1 1 1
2 2 3
B 表
name pwd email
3 3 [e-mail]
4 4 [e-mail]

如何查询这两个表name,pwd列并且将数据罗列上去

结果
name ,pwd
1 1
2 2
3 3
4 4

[bill024]

select name,pwd from A
union all
select name,pwd from B

[miaoyuanyan]

要用到表联合的

[-狙击手-]

declare @ta table (name char(1),pwd char(1),id  int)
insert @ta select '1',           '1',     1 
insert @ta select '2'    ,       '2'  ,   3 
declare @tb table (name char(1),pwd char(1), email varchar(20))

insert @tb select '3'     ,      '3' ,      '[e-mail]' 
insert @tb select '4'    ,       '4'  ,       '[e-mail] '



select isnull(a.name,b.name) as name ,
isnull(a.pwd,b.pwd) as pwd
from @ta a
full join @tb b on a.name = b.name
order by name

/*

name pwd  
---- ---- 
1    1
2    2
3    3
4    4

*/

select name ,pwd from @ta
union 
select name ,pwd from @tb
/*
name pwd  
---- ---- 
1    1
2    2
3    3
4    4
*/

[waslee]

那要是要 结果是这样呢

结果
name pwd id email
1 1 1
2 2 3
3 3 [e-mail]
4 4 [e-mail]

[bill024]

select name,pwd,id,email=null from A
union all
select name,pwd,id=null,email from B