How about ...
select @a:=count(*) from ... where ... union select @b:=count(*) from ... where ... union select @[EMAIL PROTECTED];
PB
---
2wsxdr5 wrote:
I have these 2 queries.
SELECT count(*) gifts FROM gift g WHERE g.this and g.that
SELECT count(*) events FROM events e WHERE e.this and e.the other thing
is there a way to put these into one query.....
SELECT count(g.*) gifts, count(e.*) FROM gift g, event e WHERE . . . .
so far nothing seems to be working
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
