How about:
SELECT
l.id,
l.description,
l.build_date,
l.edit_date,
l.admin_user,
COUNT(*) AS userCount
FROM
mailroomLeadList ll,
customer c,
mailroomLead l
WHERE
l.id = ll.id
AND ll.customerid = c.id
AND c.mail_list 0
GROUP BY
l.id,
l.description,
Subject: Re: OT: SQL without Subquery
How about:
SELECT
l.id,
l.description,
l.build_date,
l.edit_date,
l.admin_user,
COUNT(*) AS userCount
FROM
mailroomLeadList ll,
customer c,
mailroomLead l
WHERE
l.id = ll.id
AND ll.customerid = c.id
AND c.mail_list 0
GROUP
Jochem,
Thanks, query worked great!
Paul Giesenhagen
QuillDesign
- Original Message -
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 3:54 PM
Subject: Re: OT: SQL without Subquery
How about:
SELECT
l.id
3 matches
Mail list logo