MS Access Sql - Using Join to list items that don't match
Posted on 2013-11-27
If I have 2 tables:
CREATE TABLE Items20123( Id VarChar(15), UserName VarChar(50))
CREATE TABLE Items2011( Id VarChar(15), UserName VarChar(50))
How do I use the join command to list all of the Id's from the Items2012 table that don't exist in the Items2011 table?
Select * from Items2012 Inner Join Items2011 on Items2012.item <> Items2011.item
But got an out of memory exception.
There are about 35,000 in each table.