SELECT a1.a1Count,a2.a1Count2 FROM ( SELECT COUNT(*) AS a1Count FROM ... ) AS al,(SELECT COUNT(*) AS a1Count2 FROM ... ) AS a2