Sum of different table counts I have 2 different query and i want to summarize their count in other query like this:

    select a,((select count(id) from foo) + (select count(id) from bar)) 
    as 'alpha' from beta;


Is there a way to do it on mysql?
It worked as,

select a,(select (select count(id) from foo) + (select count(id) from bar)) 
as 'alpha' from beta;