Bad query structure...

[ian_t_howarth]

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