SQL query builder not parsing Parentheses [message #1037398] |
Tue, 09 April 2013 10:03 |
kuldeep Singh Messages: 2 Registered: January 2013 |
Junior Member |
|
|
SQL query builder do not parse parentheses in query.So,Using sql parser it is possible to write following query-
select * from table where (A1 and A2) or A3
like this
select * from table where A1 and A2 or A3
As and has precedence over or.
But how to achieve following query using SQL query builder-
select * from table where (A1 or A2) and A3
[Updated on: Tue, 09 April 2013 10:07] Report message to a moderator
|
|
|
Powered by
FUDForum. Page generated in 0.01984 seconds