Hi,

I have following 4 sql queries .

I want to join all these 4 queries into 1 query and get the result.

SELECT COUNT(*) AS table1_count FROM table1 WHERE active=1

SELECT COUNT(*) AS table2_count FROM table2 WHERE active=0

SELECT COUNT(*) AS table3_count FROM table3 WHERE active=1

SELECT COUNT(*) AS table4_count FROM table4 WHERE active=1

Any idea?

-Thanks