I want to use SQL to select some records, joining a few tables, and picking certain fields. I then want to look at the result set in a browse window and fix some things.

I can't do it with a normal SQL Select, since it won't update the base tables.

I was thinking if I created a view of the tables with a SQL Statement in the AS clause, then I would be able to update the fields and have the data written back to the original tables?

Is this possible? Are there any hints for me?

Would you give me a sample Create SQL View statement that I could then base my own off of?