求一条查询两个表显示查询语言

[mailto520]

有两个表
T1

a b
abcd deeeasfsd
ddfd fdsafd

T2

c d
3fdsf 4333232d

我要将这两个表的查询数据显示为:
a b c d
abcd deeeasfsd
4221 fdaee67

3fdsf 4333232d
ddfd fdsafd

[hhnick]

看不懂楼主最后显示的数据从那个表来的

[pt1314917]

4221 fdaee67

这个从何而来？

[tim_spac]

select * from T1
union all
select * from T2

[mailto520]

打错了,应该是
有两个表
T1

a b
abcd deeeasfsd
ddfd fdsafd

T2

c d
3fdsf 4333232d
ddfd fdsafd

我要将这两个表的查询数据显示为:
a b c d
abcd deeeasfsd
4221 fdaee67

3fdsf 4333232d
ddfd fdsafd

[mailto520]

tim_spac
你的方法不行呀
字段都在一起去了

[chuifengde]

??
select isnull(a,'') a,
       isnull(b,'') b,
       isnull(c,'') c,
       isnull(d,'') d,
from t1 full join t2
       on t1.a=t2.c

[areswang]

declare @a table(a varchar(10),b varchar(10))
insert into @a select 'abcd','deeeasfsd'
union all
select 'ddfd','fdsafd'

declare @b table(c varchar(10),d varchar(10))
insert into @b select '3fdsf','4333232d'
union all
select 'ddfd','fdsafd'

select isnull(t1.a,'') a,isnull(t1.b,'') b,
isnull(t2.c,'') c,isnull(t2.d,'') d from
(select * from @a ) t1
full join
(select * from @b ) t2
on t1.a = t2.c
order by a desc

[mailto520]

areswang chuifengde
你们的方法还是不行

[areswang]

LZ，贴个正确格式出来

[mailto520]

表1（T1）
|----------------|------------------------------|
|字段(a) | 字段(b)
|abcd | deeeasfsd |
|ddfd | fdsafd |
|----------------|------------------------------|

表2（T2）
————————————————————————————
字段（c） 字段(d)
3fdsf 4333232d
ddfd fdsafd
————————————————————————————

我要将这两个表的查询数据希望显示为:
---------------------------------------------------------------------------
字段（A） 字段（B） 字段（c） 字段（D）
abcd deeeasfsd
4221 fdaee67
3fdsf 4333232d
ddfd fdsafd
————————————————————————————————————————————

[areswang]

declare @a table(a varchar(10),b varchar(10))
insert into @a select 'abcd','deeeasfsd'
union all
select 'ddfd','fdsafd'

declare @b table(c varchar(10),d varchar(10))
insert into @b select '3fdsf','4333232d'
union all
select 'ddfd','fdsafd'

select isnull(t1.a,'') a,isnull(t1.b,'') b,''c,''d
from @a t1
union all
select ''a,''b,isnull(t2.c,'') c,isnull(t2.d,'') d
from @B t2

[mailto520]

areswang ,谢谢

[tim_spac]

DECLARE @t1 table (f1 int, f2 int)
declare @t2 table (c1 char, c2 char)

insert into @t1 values (1,2)
insert into @t1 values (3,4)
insert into @t2 values ('a','b')
insert into @t2 values ('c','d')

select * from @t1 left join @t2 on 1=2
union all 
select * from @t1 right join @t2 on 1=2