I'm trying to insert the following condition programmaticaly:
WHERE (A not in (a,b) AND B not in (c,d)) OR B in (e,f)
I have something like this:
A.ConditionStrings = "not in (a,b)"
B.ConditionStrings = "not in (c,d)"
B.ConditionStrings = "not in (e,f)"
This works fine when it's the only condition, but if the query contains other condition, then it doesn't necessarely return the right data.
Any idea how I can add such a condition without messing up the rest?
February 21 2011, 10:28 AM