On Wed, May 11, 2011 at 8:47 PM, John <tauru...@gmail.com> wrote: > That would work if I needed to select a single column from a table. But if I > need to select multiple values (c1, c2), then it wouldn't work. Can't have > subquery with more than one column selected, in general, I think.
You can do one case for each result column. It gets wordy, fast. Normalization helps... :) Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
