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