Add Table to Select query

M

Mary

I have a select query with the following statement:

SELECT DISTINCT Customers.CustomerName, Customers.Type,
Customers.GlobalName, Customers.Email, GlobalCompare.ImportedCustomerName
FROM GlobalCompare INNER JOIN Customers ON
GlobalCompare.ImportedCustomerName Like Customers.CustomerName & "*"
ORDER BY Customers.Type, Customers.CustomerName
WITH OWNERACCESS OPTION;

There is a new Table which also has the CustomerName field. How can I
include the CustomerName field from the new table in this query?

Thank you,
Mary
 
R

Rick B

If you go into query builder and click the "add table" icon you can click
the new table. Then, create the type of join between the two tables (if one
is not created for you) and drag the fields you need.

Rick B
 
Top