I am developing an application in Access using Access as the front end and SQL Server as the back end
The following query tells me the number of records where the CustomerNumber + OfficeNumber match
between 2 tables named tblCustomers and tblProducts:
FROM tblCustomersNew As C inner JOIN tblProductsNew As P
ON C.CustomerNumber=P.CustomerNumber AND C.OfficeNumber=P.OfficeNumber
Could you tell me how to rewrite this query to find any record(s) on the
tblProductsNew table and not on the tblCustomersNew table ?