SELECT colA FROM test a UNION ALL SELECT colB FROM test b