I am trying to pull data from a table (table A), but only want to pull the records where the same ID does not appear in a second table (table .
Is this possible? Table A contains a unique ID field, which is referenced in Table B, so this field can be used to find entries for the same person.
I started with just pulling the info I wanted from one table:
SELECT * FROM A WHERE (availability = 'All') AND (site = '" & site & "') OR (availability = '" & availability & "') AND (site = '" & site & "')"
and now think I need an "AND B.ID field ....." But that is where I get lost!
I'm sure this is a very simple piece of code!
Thank you for any assistance you can provide!