sql 根据material_id的值查找processItem里material_id与其相同的值

sql 根据material_id的值查找processItem里material_id与其相同的值怎么写

大概长这样

select *
from material m left join processItem p on m.id = p.id
where m.id=1