Create a comined Customer and Supplier Telephone List

[Guest]

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

 

[Rick B]

You would need to build a UNION query.

 

[Guest]

Hi Rick,

Do I do this in SQL or can use the Query Tool.

Thanks again
GRD

 

[Marshall Barton]

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.

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

 

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