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

##</code><code>##

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