Unequal Join

[SobJim]

Hello all,

I think what I need to do is an unequal join.

I have a table that is called "Items Listing", it has all information about products in my warehouse. I want to be able to compare the Articles numbers from "yesterdaysitems Listing" to "Items Listing. I only want the differences shown. From what I read it has to be done in SQl. I have no idea how to do it.

Here is the SQl for my query.

SELECT [Item Listing].Product, yesterdayitems.Product, [Item Listing].Buyer, [Item Listing].[Acc Dept], [Item Listing].Description, [Item Listing].[Cd Variance], [Item Listing].[Prod Max Date]
FROM [Item Listing] INNER JOIN yesterdayitems ON [Item Listing].Product = yesterdayitems.Product
ORDER BY [Item Listing].[Cd Variance];


Thanks

[orange]

Look at the Unmatched query in Access help.

[SobJim]

Thanks!! Never noticed that before.