Simple task

[Lebowski]

I have a query with data in two columns:

Column A | Column B
1 2
3 4
5 6

The problem is to have all this data in only one column:

Column A+B
1
2
3
4
5
6

Any suggestions?

 

[Guest]

SELECT [Column A]
FROM TheTable
UNION
SELECT [Column B]
FROM TheTable
ORDER BY 1 ;

You might need to fiddle around with UNION or UNION ALL to get the right
results. UNION doesn't return duplicates where UNION ALL does.

Also you really can't set up a UNION query in the QBE design grid. You'll
need to do it the old fashioned way of typing it into the SQL View.