How do you find data that is not found in another table, for example, a video rental shop, a member that has not made a loan, the member's details not found on the loan table. How do i find those members using a query.
I thought it had something to do with Null searches but it didn't work...