As a Solution builder
I want be able to use some sort of priority operator on the or/and clauses when you use the "where" clause. For instance:
WHERE (A or B) and C
At the moment, it is unclear (to me) how things are prioritised and the indentation gives me an indication, but not a clear statement on how it works.
So That I do not have to spend as much time creating join queries, where I have a better understanding of how the logical operators are prioritised.
Benefits Improved query building capabilities, time saved.
- Some way to organise and/or in a way which enables me to make explicit choices on how the logical operators should be prioritised.
Customer / Originator LFV
Please sign in to leave a comment.