>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?

That's what updatable views are for. There are several settings that you have to make after the view is created to make it updatable, though: specify a key field for the table you need to update, specify updatable fields as updatable, and check "Send SQL Updates"). These are made easily in the view designer- a word of warning- the view designer does not deal well with views that contains more than one join- it creates faulty syntax, and will give errors when trying to save. You can download my eView utility from the files section here to get around this, as well as a few other helpful things.

I would begin by reading the docs on updatable views...