General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Unknown error in SQL view
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only