I have a query that has a condition that count persons whose blood pressure, weight and height are calculated whose age is greater than 3. I have made this query and this query is working fine but there is a condition that if the age is greater then 2 then do not care about blood pressure and see that height and weight is captured. Can any one tell me how can I accomplish this.
Thanks in advance.
Jump to Post
What you need to do is to group the first set of conditions (the age > 3) inside a pair of parenthesis, and then create and group the second set of conditions (the age > 2) inside another pair of parenthesis. After you have got both sets of conditions, conjunct …
All 3 Replies
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.