Rick,
Ah now the problem is clear. If the View designer can't create it correctly in the first place, how do you expect it to be able to edit it? *s*
Once you've created a complex view with code, that's how you have to maintain changes to it. Just alter the code and rerun it, that will replace the view.
>It does not give me an error. Instead, my view is created but the SQL statement is changed with brackets in inappropriate places.
>It looks like this when I see the SQL from view designer's 'Veiw SQL' menu item.