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
