Create a comined Customer and Supplier Telephone List

G

Grd

Hi,

I would like to combine a customer phone list (FirstName, LastName, Phone)
from the Customers Table with a Supplier phone list (FirstName, LastName,
Phone) so that one continous list is create.

I can't seem to create the query although I'm quite good at queries.

Any help would be greatly appreciate.

Thanks

GRD
 
M

Marshall Barton

Grd said:
I would like to combine a customer phone list (FirstName, LastName, Phone)
from the Customers Table with a Supplier phone list (FirstName, LastName,
Phone) so that one continous list is create.
Click to expand...


SELECT FirstName, LastName, Phone
FROM Customers
UNION
SELECT FirstName, LastName, Phone
FROM Suppliers
ORDER BY LastName
 
R

Rick B

That is a "special" query type. I do it using SQL. Not sure if the wizard
offers it or not. If you go to the help files and search for UNION query,
it will give you detailed instructions.
 
Top