Delete on a view

[cmacfee]

As I stated in my topic description im new to this stuff. Keeping things simple this is what I want to do.I have table1 and table2 and I have a view created showing me information on both tables. I want to be able to delete information on the view and once that has been deleted I want that information sent over to table3.I was reading an old SQL book and I found in bold letter "You cannot create a trigger on a view"So if it possible to delete information on the view how can I move that information to a table if I can't create a trigger?Anybody have any helpful ideas because I'm stumped?Thanks,Chris

[justsomeguy]

A view is basically a stored query. You can read the data, but it doesn't make sense to insert, update, or delete with regard to a view. If you wanted to remove records from the view, you need to remove them from the tables that the view is querying. There are a few ways to copy records between tables, you can use SELECT INTO, or INSERT .. SELECT for example.