Find data not found in another table

[whoisit]

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

Loan table fields: LoanId, MemberId, TitleId, DateLoanIsMade, DateLoanNeedsToBeReturned, ActualDateLoanReturned, AmountDue.

THANK YOU
if more info is needed please reply

 

[calmwind]

Try using the join property in the query

 

[whoisit]

THANKS A LOT
I now have found the inactive members
THANKS