Hi,
I am trying to identify items with no records in a sub-set, such as a customer
with no purchases. I have tried several different queries but none provide
the correct result set, eq:
SELECT Count(P.Ref)=0, C.Ref, C.Surname, C.Forename FROM Clients C JOIN
Purchases P ON C.Ref=P.Ref
Can anyone provide me with info as to the correct query structure?
TIA
__________________________________________________
Broadband from an unbeatable £15.99!
http://www.tiscali.co.uk/products/broadband/home.html?code=SM-NL-11AM
