On 15 Nov 2019, at 9:04pm, Jose Isaias Cabrera <jic...@outlook.com> wrote:
> CASE > SELECT a from t WHERE a = 'p006' idate desc limit 1 > WHEN a = NULL > THEN 'p006',1,2,'y',4,'2019-02-12' > ELSE SELECT a, b, c, 'y', e, '2019-20-12' from t WHERE a = 'p006' idate > desc limit 1 > END The thing after THEN must be an expression, not a list of expressions separated by commas. You could probably use another SELECT after THEN to retrieve the list of values, just as you have after ELSE. (Note I have not actually tried this to make sure it works.) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users