Yes, I could. But considering that I'm applying tons of logic and not just selected this would be a real mess. Not even sure I could pull it. Normalization was something I lacked with regard to previous post. But in this case, I don't think it has anything to do with it. It's just alack of dynamic sql. I can't trully construct sql statement piece by piece with SQL db as I did with Oracle. Just wanted to confirm.
On Wed, May 11, 2011 at 9:58 PM, Nico Williams <n...@cryptonector.com>wrote: > 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 > -- ~John _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
