display all data from one table not in another table

[Lazza123]

Hi guys,

quick question,

does anyone know how to display all the data from one table thats not entered in the second table?

eg, members have IDs, and members need to make payments. i want to be able to record all the member IDs from members, thats not in the payments table.. does anyone know how to do this? does anyone know the SQL commands for it? i have tried for ages using NOT IN and sub queries, but these have worked to no avail.

Thnx

 

[Lightning]

Have you tried the Find Unmatched Query Wizard?

In the Query window, Click New, Select Find Unmatched Query Wizard, and then follow the dialog box instructions.

HTH

Lightning