Using CASE in a Query Table
Hi, I'm trying to use a CASE in a Query table, but I'm unable to do it.
It should be as simple as:
SELECT "FIELD 1", "FIELD 2"
CASE WHEN "FIELD 2" = "CASE1" THEN "ABCD"
ELSE "WXYZ"
END
FROM "Potentials"
What am I doing wrong or how could i do it?
Thank you very much (I'm new at both sql and zoho reports).