>Thanks...
>
>I got my view created fine. I cannot edit it in the view designer because it says my query is too complex.
>
>I need to know how to make it updatable. Here is my command to create the view. Can anyone tell me what I am missing to make it updatable?

---

The view designerr cannot work with union statements.
About the updating.
In chapter 8 of the Programmers guide half way there is a sample how to have updatable views.