Re: showing also value '0' with aggregate count()

Am Donnerstag, 27. September 2001 17:47 schrieb David Christian:
> Hmmm... I'm  using 7.1.2, and don't know if you should upgrade or
> not.
>
> Can you use UNIONs?
>
> select name, count(client_id) from sales, clients where client_id =
> id group by name UNION select name,0 from clients where not id in
> (select client_id from sales) order by 2;


Oh yes! Thanks. i dont need to upgrade. thats fine. thanks to randal
too.

janning

--
Planwerk 6 /websolutions
Herzogstra�e 86
40215 D�sseldorf

fon 0211-6015919
fax 0211-6015917
http://www.planwerk6.de