Received: from redbox.venux.net (redbox.venux.net [216.47.238.10]) by hub.org (8.9.3/8.9.3) with ESMTP id NAA06777 for ; Sun, 19 Dec 1999 13:26:26 -0500 (EST) (envelope-from mitch@venux.net) Received: from doot2 (dyn2-tnt1-117.kalamazoo.mi.ameritech.net [206.141.247.117]) by redbox.venux.net (Postfix) with SMTP id 49CC02E227 for ; Sun, 19 Dec 1999 13:20:42 -0500 (EST) Message-ID: <014d01bf4a4e$a41e0ac0$0300000a@doot.org> From: "Mitch Vincent" To: References: Subject: New count() question Date: Sun, 19 Dec 1999 13:26:59 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 Ok, so it's two queries. I have another intersting problem though.. Example of one of my count queries : select count (*) as total from applicants as a,applicants_states as s,resume_search as re where a.app_id=s.app_id and a.app_id=re.app_id and re.user_id=291 That's all well and fine except that it only counts the total from the applicants table, not the total from the rest of the query. I know I'm just not doing something right (obviously), can someone lend a hand? I've played with grouping but can't seem to get the syntax all right. Thanks (again)! -Mitch