Simple task

L

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?
 
J

Jerry Whittle

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.
 
Top