Re: Bad query structure...

[Petr Vileta]

> 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

SELECT Count(P.Ref) as Counter, C.Ref, C.Surname, C.Forename FROM Clients C
JOIN
Purchases P ON C.Ref=P.Ref WHERE Counter=0 GROUP BY C.Ref


Petr Vileta, Czech republic