Matching Query not working

[Patrice K via AccessMonster.com]

I have a simple database with contact information last name, address, phone
number. There are three tables and I would like to check to see what info is
missing from one table to the next. I have done an unmatched query, table 1
to table 2 and table 1 to table 3. I would like a query to see what
information is on table 1 but not on table 2 or table 3. For some reason my
OR statement is not working.

SELECT [Table 1].LAST_NAME, [Table 1].MAILING_ADDRESS, [Table 1].CITY_TOWN
FROM ([Table 1] INNER JOIN [Table 2] ON [Table 1].ID = [Table 2].ID) INNER
JOIN Table 3 ON [Clients 32503].ID = Table.ID
WHERE ((([Table 2].LAST_NAME) Is Null)) OR (((Table 3.LAST_NAME) Is Null));

Any Help

Pat

 

[giorgio rancati]

Hi, Pat

use the LEFT JOIN

 

[giorgio rancati]

WHERE [Table 2].ID) Is Null OR Table 3.ID Is Nul;

ops..

WHERE [Table 2].ID Is Null OR Table 3.ID Is Nul;

Bye
Giorgio