query 1: CREATE TEMPORARY TABLE temp_table1 AS SELECT * FROM lookup_table JOIN ...

INSERT INTO dest_table SELECT * FROM temp_table1

query 2: INSERT INTO dest_table SELECT * FROM lookup_table JOIN ...