I want to create a trigger for the following two codes in table2
First I want to delete table1 (it has 3 columns only).
Then I want to fill up the three columns values from table t which is an output by combining table2 and table3
Table3 is fixed table, Table2 data is deleted in every 3 days and added new data. Every time table2 is added with new data, I want table1 data should be deleted and the following codes to be run.
delete from table1
insert into table1
select field1, field2 field3 from
(select field1, field2, field3 from
inner join table3 on table2.field2 = table3.field2)