Having a slight problem with a CASE statement. I need to show either the value of the acttax or tinclusive fields based on the value of the TaxRate field.
I am using the following code which produces an error and I can not figure out the message...
Code: Select all
SELECT "jobid",
"TaxRate",
"acttax",
"tinclusive",
CASE
WHEN "TaxRate = 0 THEN "tinclusive"
ELSE "acttax"
END as "offset"
FROM "ccTaxes"