RE: newbie - linking queries with dynamic where conditions

2002-12-12 Thread Adolfo Bello
rt; > -Original Message- > From: news [mailto:[EMAIL PROTECTED]] On Behalf Of Max Clark > Sent: Thursday, December 12, 2002 5:30 PM > To: [EMAIL PROTECTED] > Subject: Re: newbie - linking queries with dynamic where conditions > > > So I am trying to accompli

Re: newbie - linking queries with dynamic where conditions

2002-12-12 Thread Max Clark
So I am trying to accomplish something like this: select a.domain, a.transport, sum(c.recipient_count) sum(c.recipient_size) from transport as a, acl as b, recipientstats as c where a.id=b.transportId and b.adminId='1' and c.recipient_email like '%a.domain'; But I know I am missing something beca