SQL merge 3 historic table

• arif.coskun

  Grasshopper

  Points: 20

  More actions

  July 29, 2010 at 12:59 am

  #223846

  Hi all,

  i have 3 tables,and i wanna merge them looking at sdatekey and edatekey.

  Table1

  sdatekey edatekey title ID

  10 15 x 12

  Table2

  sdatekey edatekey staffstatu reason ID

  9 12 y a 12

  Table3

  sdatekey edatekey level tel address ID

  5 11 z b c 12

  i wanna this resultset;

  sdatekey edatekey title staffstatu reason level address tel

  5 9 NULL NULL NULL z c b

  9 10 NULL y a z c b

  10 11 x y a z c b

  11 12 x y a NULL NULL NULL

  12 15 x NULL NULL NULL NULL NULL

• July 29, 2010 at 2:39 am

  This was removed by the editor as SPAM

• sumit.agrawal

  SSCommitted

  Points: 1616

  More actions

  July 29, 2010 at 2:46 am

  #1199658

  U can use Union clause to merge...