0

logical functions in a SELECT statement?

Is it possible to use any logical functions when defining a SELECT statement? Or do I have to use many separate SELECT statements?

 

Example of what I use now:

 

let x := Field1

if x != 3 then

     select Table2 where Field1 = x and Field2 = 0

else

     select Table2 where Field2 = 0

end

 

It would be nice to make something like:

 

let x := Field1

select Table2 where (if x != 3 then Field1 = x and end) Field2 = 0

1 reply

null
    • Mrk
    • 3 yrs ago
    • Reported - view

    Nevermind, figured it out.

     

    Solution if anyone is interested:

    let x := Field1

    select Table2 where (if x != 3 then Field1 = x else 1 end) and Field2 = 0

Login to reply

Content aside

Categories

View all topics
  • 3 yrs agoLast active
  • 1Replies
  • 153Views