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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
