problem in query

• mahmoud.inirat

  Valued Member

  Points: 61

  More actions

  September 11, 2008 at 3:01 am

  #212555

  i have two table like the following:

  name course

  ------- ---------

  mahmoud c++

  osam java

  and the second column as the following:

  name course1

  --------- ---------

  mahmoud db

  osama c#

  najeeb vb.net

  yahya xml

  please help me to make the following result

  name course course1

  --------- ---------- ------------

  mahmoud c++ null

  osama java null

  mahmoud null db

  osama null c#

  najeeb null vb.net

  yahya null xml

  thank you

• Andras Belokosztolszki

  SSC-Insane

  Points: 22031

  More actions

  September 11, 2008 at 3:14 am

  #870174

  Assuming the two tables are tableA and tableB you can do:

  SELECT name

  , course

  , NULL AS course1

  FROM tableA

  UNION ALL

  SELECT name

  , NULL AS course

  , course1

  FROM tableB

  Regards,

  Andras

  ---

  Andras Belokosztolszki, MCPD, PhD
  GoldenGate Software