"not equal" join?

[lymi6977]

I have imported data where I need to strip out (exclude) certain records. I will then take those records to invoice from.

How could I do a "not equal" join?

Tables: tblMarchTransactions, tblPLSUserIDs

I basically need to see all fields in tblMarchTransactions, but I need to exclude any transactions where tblMarchTransactions.UserID = tblPLSUserIDs.UserID.

Suggestions?

Thanks for your help.
lymi6977

 

[PHV]

SELECT ...
FROM tblMarchTransactions [!]LEFT[/!] JOIN tblPLSUserIDs ON tblMarchTransactions.UserID = tblPLSUserIDs.UserID
WHERE tblPLSUserIDs.UserID IS NULL

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lespaul]

Do you also have tblFebruaryTransactions and tblAprilTransactions? Is there a valid reason for such a segregated structure? What do you do if you need yearly totals?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design