Hello. I'm trying to create a query to join on two tables.
Table1 has id and name. Table2 has userID and itemID.
Table1 id and table2 userID are the same. For a specific itemID I want to select all names from table1 where the userID in table2 does not exists.
For example, here is some test data.
Table1
1 Bill
2 Bob
3 Joe
Table2
1 1
2 1
3 2
If I wanted to get all names where the userID wasn't listed for itemID 1, it would return Joe. Similarly if I wanted to get all names where the userID wasn't listed for itemID 2, it would return Bob and Joe. Finally, if I wanted to get all names where the itemID was not equal to 1 or 2, it would return Bill, Bob, and Joe.
How do I join the two tables to do this? Thanks.