count and grouping help

[SAbijoux]

Hi guys,
I need to do a count from two tables without using distinct.
Say,
select count(field1) from table1 group by someval;
and
select count(field2) from table2 group by someval;

How do I accomplish this and having only 1 resultset?
I hope that makes sense. Thanks

[aherraiz]

Hi guys,
I need to do a count from two tables without using distinct.
Say,
select count(field1) from table1 group by someval;
and
select count(field2) from table2 group by someval;

How do I accomplish this and having only 1 resultset?
I hope that makes sense. Thanks

I think what you want is a UNION and then sum so:

SELECT SUM(query_one.my_count) FROM
(SELECT COUNT(field1) AS my_count FROM table1 GROUP BY someval
UNION
SELECT COUNT(field2) AS my_count FROM table2 GROUP BY someval) as query_one
 

That should give you 1 number sum of the two counts. If you just run the inner query you'd get two rows one for each count.