[SOLVED] SUM of two select results

[The Little Guy]

I thought that this would work... but it doesn't, I would like to get a total from both returned results, basically this should always return one row and one column. It should contain a number 0+.

 

SELECT SUM((SELECT COUNT(m.id) FROM mailbox m WHERE m.status = '0')
UNION
(SELECT COUNT(f.id) FROM friends f WHERE f.acc = '0')) as total

 

How could I fix it?

[bluejay002]

try this:

 

SELECT SUM (totalTable.total) as total
FROM (
SELECT COUNT(m.id) as total
FROM mailbox m 
WHERE m.status = '0'
UNION
SELECT COUNT(f.id) as total
FROM friends f 
WHERE f.acc = '0'
) as totalTable

 

did this work?

 

Jay,

[The Little Guy]

Thanks, Works!