>>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.
Ok. Thanks!
Renoir