-- 1. 조인 후 카운트 -- SELECT c.code , c.name , c.eng , COUNT(*) cnt FROM code c , data d WHERE c.code = d.code AND d.dt LIKE '2017%' GROUP BY c.code, c.name, c.eng HAVING COUNT(*) >= 2 ; -- 2. 카운트 후 조인 -- SELECT c.code , c.name , c.eng , d.cnt FROM code c , (SELECT code , COUNT(*) cnt FROM data WHERE dt LIKE '2017%' GROUP BY code HAVING COUNT(*) >= 2 ) d WHERE c.code = d.code ;