Well, select column A from table B, kind of implies that that column A can only come from table B. This is what most people would think I would guess.
RBS On Sun, Mar 22, 2015 at 10:27 PM, Igor Tandetnik <igor at tandetnik.org> wrote: > On 3/22/2015 11:50 AM, Bart Smissaert wrote: > >> Still, in this particular case it seems odd as there is only one column >> and >> one table in the sub-select. >> > > I'm not sure I understand what significance you ascribe to this fact. Why > again should the number of columns or tables in subselect matter? > > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >