Your code will probably look something like this:

BEGIN TRANSACTION

INSERT INTO Table3
SELECT *
FROM Table1, Table2
WHERE DATE BETWEEN BeginDATE AND EndDATE;

DELETE FROM Table1, Table2
WHERE DATE BETWEEN BeginDATE AND EndDATE;

END TRANSACTION