How to implement a query that return data with no match

[eclypz]

Hi, i have read some posts of inner join and outer join, but no one
could help me to solve my problem

I have 2 tables

1) tblRecords (having, article; User;date in; date out; service)
2) tblUsers (user)

what i need is to select from tblRecords those records that does not
match the users in the tblUsers, so if for example i have 20 records
in the table 1 (all from diferent users) and in table 2 i have 3
users, the result will be like if i delete from tblRecords the records
that match tue users in tblUsers. But i don't want to delete those
records... so how can i make a select query to help me with this?

 

[Guest]

I think this is what you want (Unmatched query) --
SELECT tblRecords.User, tblRecords.article, tblRecords.[date in],
tblRecords.[date out], tblRecords.service
FROM tblRecords LEFT JOIN tblUsers ON tblRecords.User = tblUsers.User
WHERE (((tblUsers.User) Is Null));

 

[eclypz]

Yes

this is it!!!

thanx so much!