I can almost guess an answer based on you sample query. Please post your
table structures and we will get it right the first time (SHOW CREATE
TABLE xxxx).
Yours,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
ian_t_howarth@stripped wrote on 07/20/2004 09:24:40 AM:
> 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
>
>
>
>
> --
> MySQL Windows Mailing List
> For list archives: http://lists.mysql.com/win32
> To unsubscribe: http://lists.mysql.com/win32?unsub=1
>
