>Hello:
>I am trying to use an updatable view with a left join. I have
>two tables-PErsonel, address. I am left joining address on personl
>so I will have null records in my view -when
>someone from personel doesn't have a record in address.
>--YOu can't update the view b/c it won't automically
>insert a record into address-it says" update conflict"--
>Solution???
I know in SQL Server, you cannot update a view on multiple tables. You may have to do the background work yourself on each table individually, or do separate updates depending on the underlying table.