combine 2 queries in Union

• tracmonali

  Mr or Mrs. 500

  Points: 551

  More actions

  April 26, 2011 at 10:51 am

  #249769

  Hello, I wish to combine 2 rows of result set of UNION. Example

  Select A,B,C,D

  from tabl1

  Union

  Select A,B,C,E

  from tbl2

  I wish the output to be

  A, B, C, D,E

• ChrisM@home

  SSC-Insane

  Points: 24260

  More actions

  April 26, 2011 at 11:14 am

  #1316045

  Select A, B, C, D, E = CAST(NULL AS CorrectDataType)

  from tabl1

  Union

  Select A, B, C, D = CAST(NULL AS CorrectDataType), E

  from tbl2

  ---

  [font="Arial"]^{Low-hanging fruit picker and defender of the moggies}[/font]

  For better assistance in answering your questions, please read this[/url].

  ---

  Understanding and using APPLY, (I)[/url] and (II)[/url] Paul White[/url]

  Hidden RBAR: Triangular Joins[/url] / The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden[/url]