Column Concatenation Is it possible to concatenate the rows from two/more different columns into one new column ?
Example:

 C1     C2      C3
---- + ---- =&gt; ----
 a      d       a
 b      e       b 
 c      f       c
                d 
                e
                f
this should do the trick if you are using T-SQL

select C1, C2, a.Chuck
from testa
right join  (select C1 as Chuck from testa UNION ALL select C2 as Chuck from testa) as a  ON a.Chuck = testa.C1