multiple-select-query

What is wrong in my MYSQL Query?

SELECT ( SELECT SUM(IF(status = 'Active', 1, 0)) AS `univ_active`, SUM(IF(status = 'Inactive', 1, 0)) AS 'univ_inactive', Count(*) FROM online_university ) AS tot_university, ( SELECT SUM(IF(status = 'Active', 1,0)) AS `user_active`, SUM(IF(status = 'Inactive', 1,0)) AS 'user_inactive' Count(*)...

MySQL is there a Single Select to Query Various Unrelated Values from a database?

I saw somewhere what seemed to be nested selects, one "master" select on the "outside" and a series of selects inside- is this possible? I'm not talking about joins as there is particular relation between the selects. I seem not to be explaining myself very well. I want to do a single query which will pull out a series of stats from var...