On 1/26/2020 9:44 PM, Jose Isaias Cabrera wrote:
CASE ( SELECT WYear FROM t2 WHERE pid = a.a ) WHEN c.WYear = 2020 THEN “YES” ELSE “NO” END ) AS DIGITAL
This should probably be simply case c.WYear when 2020 then 'YES' else 'NO' end or equivalently case when c.WYear=2020 then 'YES' else 'NO' end -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users