Select distinct a.client_id,a.client_name
from clients a join projects b on a.client_id = b.client_id
where b.project_name like '%ERP%'
from clients a join projects b on a.client_id = b.client_id
where b.project_name like '%ERP%'
select * from clients where client_id in (select client_id from projects where 项目名称='xxx')