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, > 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, > l.build_date, > l.edit_date, > l.admin_user, > ORDER BY > description DESC > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
