merging two colls into one

• • Reply

  13 years ago

  by Rumble

  Chagay S

  IL, United States

  Joined 18 years ago

  hi

  is there a way to merge two cols in to one?

   

  this is how my data looks:

  Name               Second_Name

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

  Ron                   Dan

  Dan                   Mike

  Linda                 Dan

  Sean                 Ron

  Karen                Dan

  Dan                  Jane

  Ron                   Dave

   

  what i want to do is merge all of Dan's second names (only where Dan appears as either a first name or a second name) to one single collum

  so it will look like that:

   

   

  Names

  ----------

  Ron                  

  Mike

  Linda

  Karen

  Jane

  
  all of those are  Dan's other name

  I tries to create one SELECT inside the main SELECT but still it gave me two collums aventually.

  
  anyone has an idea?

  thank you.

  Report abuse