On 27 Jan 2020, at 2:44am, Jose Isaias Cabrera <jic...@outlook.com> wrote:
> CASE
> (
> SELECT WYear FROM t2 WHERE pid = a.a
> )
> WHEN c.WYear = 2020 THEN “YES”
> ELSE “NO” END
That's not the structure of a CASE statement.
After CASE comes an expression.
After WHEN comes another expression.
If they equal one another, then the the bit after the THEN is returned.
You want something more like
SELECT
(CASE WYear WHEN 2020 THEN 'YES' ELSE 'NO' END) AS DIGITAL
FROM t2 WHERE pid = a.a
but you'll have to fit this in with how your overall SELECT works.
Sse "The CASE expression" on this page for more details:
<https://sqlite.org/lang_expr.html>
Also note that to quote strings you use a single apostrophe at both ends, not
directed speech marks, just as you had in your INSERT commands.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
