AnsweredAssumed Answered

Execute sql "or"

Question asked by Hudi on Jan 16, 2013
Latest reply on Jan 17, 2013 by beverly

Hey All,

 

I'm tryting to use the "or" clause inside an execute sql function and am returning "?"/

 

ExecuteSQL (

 

 

"SELECT Count("_K_ID_Student")

FROM "Student"

  WHERE "class_id" = ? and ("GPA" >? or "Active" ≠ ?")

 

 

 

; "" ; "" ; Class::K_ID; ;3.0; "1" )

 

This is just a sample but if you wanted to get a count of all the students who are in a class who have a gpa over 3.0 or are incative. This example is really sorry, but I hope my point is clear. How do you place an "and" clause and an "or" in the same sql function.

 

 

Cheers

Outcomes