Query Question
-
- Posts: 18
- Joined: Tue Oct 10, 2017 12:44 pm
Query Question
Hi Everyone, ____This may seem pretty lame since I am digging back into my old high school computing days, but I am having some problems running some queries....____Basically, I have a simple query that looks something like this:____var1 equal to True__AND var2 equal to "ABC"__AND var3 not equal to "DEF"__AND var4 equal to "GHI"______What I want to have is something like the following:______{ var1 equal to True__AND var2 equal to "ABC"__AND var3 not equal to "Y"__AND var4 equal to "DEF"__}____AND____{ var1 equal to True__AND var2 equal to "ABC"__AND var3 equal to "Y"__AND var4 equal to "GHI"__}____But I can^t figure out how to do this in R&R, or figure out the equivalent logic.____Thanks in advance for any help.____Chris
=> RE: Query Question
Do you just need some extra parentheses to force the order of eval and an OR?__The expression below would give you everything with a True Var1 and and a Var2 ABC along with the non-Y var 3^s with a Var4 DEF and the var3 Y^s with a var4 GHI.______var1 equal to True AND var2 equal to "ABC" and((var3 not equal to "Y" AND var4 equal to "DEF") or (var3 equal to "Y" AND var4 equal to "GHI"))______Kathleen__R&R Support
-
- Posts: 18
- Joined: Tue Oct 10, 2017 12:44 pm
==> RE: Query Question
The Parentheses pretty much solve my problem, but how do I do that in R&R?
-
- Posts: 18
- Joined: Tue Oct 10, 2017 12:44 pm
===> RE: Query Question
Never mind. I figured out the parentheses.