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