>How can I change the logic of the SQL Where clause using the View Designer. Meaning, the SQL is displaying
>
>

>...AND This = That OR (Here = There)
>

>
>but what I want is
>
>

>...AND (This = That OR Here = There)
>

>
>instead. Note the position of the paranthesis. Thanks!
>
>Regards, Renoir

AFAIK, there's no way to get the view designer to do this- consider creating this view with code using CREATE SQL VIEW.