It would help if you posted the DDL for the tables, some sample data for the tables and the expected results based on the sample data.

Do you insert data from Scratch that doesn't exist in Live?

Do you delete data from Live that doesn't exist in Scratch?