select id1 from test1 LEFT JOIN test2 ON id2 = id1 where id2 IS NULL
select a.erpid from materiel_info a
LEFT JOIN materiel_info_123 b ON a.erpid = b.erpid
where b.erpid IS NULL
select id1 from test1 LEFT JOIN test2 ON id2 = id1 where id2 IS NULL
select a.erpid from materiel_info a
LEFT JOIN materiel_info_123 b ON a.erpid = b.erpid
where b.erpid IS NULL