I have to insert data into archive table called Archive_table from Table A based on a date column in Table C.
Table A is parent and it has child table, Table B and id1 column in Table A is foreign key in Table B.
Table B has another parent table, Table C where ID2 is foreign key in Table B from Table C.
Table C has date column Businessday, which I need to use for archiving 90 day old data from Table A and insert into Archive_table.
Please advise how I can achieve this.