Hi all,
I get an unknown error in creating sql view.
Below is a sql statement issue by me:

CREATE SQL VIEW report1 REMOTE CONNECTION connect1 AS SELECT * ;
FROM vendor WHERE vcode>='H' and (vtype='T' or region='CA') ;
ORDER BY vcode, vname

And below is the sql statement created itself:
(can be previewed when modify the sql view)

SELECT * FROM vendor WHERE vcode>='H' and vtype='T' or (region='CA') ;
ORDER BY vcode, vname

The difference is the bracket : (vtype='T' or region='CA') do not
correct, which generated as : (region='CA')
This will cause a big difference in results generated.
Can anyone explain this and how to correct it ?

Thanks,
Samuel