有两个表
T1a b
abcd deeeasfsd
ddfd fdsafdT2
c d
3fdsf 4333232d我要将这两个表的查询数据显示为:
a b c d
abcd deeeasfsd
4221 fdaee67 3fdsf 4333232d
ddfd fdsafd
T1a b
abcd deeeasfsd
ddfd fdsafdT2
c d
3fdsf 4333232d我要将这两个表的查询数据显示为:
a b c d
abcd deeeasfsd
4221 fdaee67 3fdsf 4333232d
ddfd fdsafd
select * from T1
union all
select * from T2
有两个表
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
你的方法不行呀
字段都在一起去了
select isnull(a,'') a,
isnull(b,'') b,
isnull(c,'') c,
isnull(d,'') d,
from t1 full join t2
on t1.a=t2.c
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
你们的方法还是不行
|----------------|------------------------------|
|字段(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
————————————————————————————————————————————
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
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