有两个表
T1a            b
abcd       deeeasfsd
ddfd         fdsafdT2
 
c           d
3fdsf      4333232d我要将这两个表的查询数据显示为:
a            b                   c            d
abcd       deeeasfsd
4221       fdaee67                                 3fdsf      4333232d
                              ddfd         fdsafd

解决方案 »

  1.   

    4221               fdaee67 这个从何而来?
      

  2.   


    select * from T1
    union all
    select * from T2
      

  3.   

    打错了,应该是
    有两个表 
    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
      

  4.   

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

  5.   

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

  6.   

    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
      

  7.   

    areswang chuifengde 
    你们的方法还是不行
      

  8.   

    表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
    ————————————————————————————————————————————
      

  9.   

    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
      

  10.   


    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