I am looking to create a SQL Query to move records from one table to another table based on ID values inside of a third table (a cross reference table if you will... telling the query which records to move from Table 1 to Table 2)
I have three tables.
Table1 has the records I want to move records from.
Table2 has the records I want to move records to.
Table3 has the ID values of the records to be moved from Table1 to Table2.
All three tables have the same record ID identifier field, and for the sake of discussion here, let's call it RecordID.