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
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
Hi-
I am trying to write a sql query that will output (domain, transport,
sum(count), sum(size)) from multiple tables for many records.
When the domain field is dynamic based on the adminId passed to the query,
how do I execute the second query at the same time?
Thanks in advance,
Max
select a.