Found the answer with Case When
asked
Still learning how to write SQL queries
It sounds like you need a CASE statement
case when productid = 27 then ‘Commercial’
when productid = 29 then ‘Point of Service’
end
17 People are following this question.
