You´re missing the GROUP BY clause
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'
GROUP BY a.domain,a.transport;
-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 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 because of the error.
Can anyone point me in the right direction?
Thanks in advance,
Max
Max Clark [EMAIL PROTECTED] wrote in message
ataq2r$ev1$[EMAIL PROTECTED]">news:ataq2r$ev1$[EMAIL PROTECTED]...
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.domain, a.transport from transport as a, acl as b where
a.id=b.transportId and b.adminId='1'; select sum(count), sum(size)
from stats where email like '%a.domain';
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try:
http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php