>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.
Erik Moore
Clientelligence