DELETE my_new_table WHERE exists ( SELECT 1 from part_group WHERE part_group.part_group = my_new_table.part_group ) #### INSERT part_group(part_group) SELECT part_group FROM my_new_table