I am developing an Access application using SQL Server 2005
The following gives me the records that match between the 2 tables:
SELECT Right(C.OfficeNumber,3) + ' ' + C.CustomerNumber AS [Account Number]
FROM dbo.tblCustomersNew AS C
INNER JOIN dbo.tblProductsNew AS P
ON C.CustomerNumber = P.CustomerNumber
AND C.OfficeNumber = P.OfficeNumber
How do you get the records that don't match between the 2 tables?