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