Add Table to Select query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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