I have a database holding some default data depending on a variable. I want to create a query which copies the default data in to another table as well as insert some other data
INSERT table_1 (id, value1, value2)
SELECT value1, value2 FROM table_2 WHERE group = '1',id=2
Is it possible in one statement? Or will I have to do this as two statements?