I have two tables. First table has 3,000 - 4,000 records [userID, firstname, lastname, dateJoined, etc...]. Second table has about 100 records [userID, status, date, etc ...]. The database is MySQL v4.0.27 and I'm talking to it with phpMyAdmin 2.6.4-pl2.
What I want to accomplish:
I want to return all records in the FirstTable where the userID does not exist as a userID in the SecondTable. This sounds simple to me but I just haven't been able to get it to work.
Any advice from the fine minds at dbforums.com would be greatly appreciated.