select * from irac

select distinct shurui, tsusho, a.ippanmei, seibun, a.keito, sayokiko, sayoten from kihon as a
left join irac as b on b.keito = a.keito or b.ippanmei = a.ippanmei where yoto = '殺虫剤';