DELETE FROM opensubmit_assignment_test_machines; INSERT INTO opensubmit_assignment_test_machines (assignment_id, testmachine_id) SELECT a.id, t.id FROM (SELECT id from opensubmit_assignment) a, (SELECT id from opensubmit_testmachine) t;