There is table1 table2, table3.
In table1 need to select all column `Order_ID` values where column `Spec_ID` values = 1
Then, all selected `Order_ID`find in table2 `Order_ID` and copy all rows with that ID's to table3.

I know how to insert rows to other table, but I cant figure out how to select multiple values and use that multiple values.