counting records in 2 tables using 1 query

[Chris W]

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

[Chris Hope]

Chris W 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

What's wrong with two queries?

--
Chris Hope - The Electric Toolbox - http://www.electrictoolbox.com/

[Bill Karwin]

Chris W 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.....

If you use MySQL 4.1, you have access to subqueries:

SELECT g2.gifts, e2.events
FROM
( SELECT count(*) AS gifts FROM gift g WHERE g.this and g.that ) AS g2
JOIN
( SELECT count(*) AS events FROM events e WHERE e.this and e.other ) AS e2

But this seems like more complexity than it's worth. If I were given
this task, I would just run two queries.

Regards,
Bill K.