INSERT INTO real_table R
SELECT * FROM scratch S
WHERE NOT EXISTS (
  SELECT 1 FROM real_table
  WHERE key_val1 = S.key_val1 AND key_val2 = S.key_val2 AND ...
)