I need to return a field “Flag” based on the state of two other fields
SELECT flag as (field1=3 and field2=9) from mytable
guess I’m having a senior moment as to why this is not right
I need to return a field “Flag” based on the state of two other fields
SELECT flag as (field1=3 and field2=9) from mytable
guess I’m having a senior moment as to why this is not right
yup a senior moment indeed
SELECT (field1=3 and field2=9) as flag
all the right words, wrong sequence