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