Help !!!! 2 Tables 2 Fields Merge by a querry

[aamer]

Please guide me how can I do the following in a Querry

I have 2 Tables
Table A has a field "Customers"
e.g ABC , DEF, GHI

Table B has a Field "Suppliers"
e.g RST, UVW, XYZ

I want to create a querry where customers & suppliers merge and I get the result in 1 field

ABC
DEF
GHI
RST
UVW
XYZ



How can I do this, am totally lost.

[pbaldy]

Try a UNION query:

SELECT Customers
FROM TableA
UNION ALL
SELECT Suppliers
FROM TableB

[aamer]

thx it worked

[pbaldy]

Happy to help.