> Can anyone help me with creating temporary tables in place of the views, > which are available during runtime, which have the same fields and data > as my view such that when one table is updated, the results are appended > to the temporary table
Why not just insert the content of the view into the temp table? insert into tmp_view_1 select * from view_1