On Wed, 15 Sep 2004 12:55:24 -0400, Jean-Luc Lachance <[EMAIL PROTECTED]> wrote: > Add : > > AND count(user_tasks.task_id) > 0 in the where clause.
I get the error: aggregates not allowed in WHERE clause -- Greg Donald http://gdconsultants.com/ http://destiney.com/ ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings