I have 2 tables. I want to show a list of all records that DO NOT have related records. I want to use SQl to do this. I am not sure how in SQl to return NOT results.
INNER JOIN table2
I am guessing I will return all the ID that are Valid. I want the oppisite. Any ideas