INSERT INTO sp_err
SELECT * FROM sp
WHERE NOT EXISTS (
    SELECT 1
    FROM supplier
    WHERE sp.num = supplier.num
)