Subquery on same table problem

[DaveTappenden]

I have a simple table containing transaction codes.
I need to produce a query listing transactions of a certain type eg "XYZ" where NO transaction of another type eg "ABC" exist anywhere else in the same table. I am trying to avoid using a lookup, but just can't work out the subquery syntax, as it must act on the same table.

 

[GoDawgs]

Kinda confused...but I think this is near what you are looking for:

SELECT *
FROM Table
WHERE TransactionType="XYZ"
AND TableID NOT IN (SELECT TableID FROM Table WHERE TransactionType = "ABC&quot

Hope that helps...

Kevin

 

[DaveTappenden]

Hi Kevin

That works a treat thanks.