if you can help me

• d.m.amine

  Old Hand

  Points: 312

  More actions

  April 22, 2010 at 8:00 am

  #234137

  hello everybody

  this's my table

  ID | HT | Adresse1 | Adresse2

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

  1 | 1 | AD | DS

  1 | 2 | BS | HG

  2 | 3 | XD | JH

  i need to have a in result like this in one column

  Result

  -----

  AD

  BS

  DS

  Hg

  ------

  thanks

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  April 22, 2010 at 8:36 am

  #1156150

  Same as here

  -- Gianluca Sartori

• danarbradshaw@yahoo.com

  Grasshopper

  Points: 24

  More actions

  April 22, 2010 at 8:47 am

  #1156163

  or ...

  select Adresse1 from Test

  union

  select Adresse2 from Test