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
-- Chris W
Gift Giving Made Easy Get the gifts you want & give the gifts they want this holiday season http://thewishzone.com
"They that can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety." -- Benjamin Franklin, 1759 Historical Review of Pennsylvania
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
