Hi all,

How can I do a SQL to move a bunch of rows from one table to another
(identical) table?

I want to move all the rows, where current_date - 30 from tableA to TableB
then remove the rows from tableA

Help with this SQL would be greatly appreciated.
Happy new Year
Daniel