How to implement a query that return data with no match

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eclypz - 26 Oct 2007 16:17 GMT

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?

Reply to this Message

KARL DEWEY - 26 Oct 2007 17:09 GMT

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));

Signature

KARL DEWEY
Build a little - Test a little

> Hi, i have read some posts of inner join and outer join, but no one
> could help me to solve my problem :(
[quoted text clipped - 10 lines]
> 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?

Reply to this Message

eclypz - 26 Oct 2007 19:31 GMT

Yes :)

this is it!!! :)

thanx so much!

--
Egidio aka eclypz

Reply to this Message