SELECT emp , SUM(subtotal) AS total FROM ( SELECT emp , COUNT(*) AS subtotal FROM A GROUP BY emp UNION ALL SELECT emp , COUNT(*) FROM B GROUP BY emp ) AS d GROUP BY emp HAVING total <= 80