Licson Lee says to YSITD SELECT * FROM (SELECT COUNT(*) AS count, t1.name FROM table1 AS t1 INNER jOIN table2 AS t2 ON (t1.id = t2.id) GROUP BY t1.name) WHERE name = 'ouo'