Nevermind. They are the same once you add: insert into bogus values(5,6,7);
> sqlite> CREATE TABLE bogus(x,y,z); -- empty > > sqlite> select a, (select b + 1 as c from bogus) as d from (select 1 as a, 2 > as b) as Table1; > a d > ---------- ---------- > 1 > > sqlite> select a, (select b + 1 as c from (select 5 as x, 6 as y, 7 as z)) as > d from (select 1 > as > a, 2 as b) as Table1; > a d > ---------- ---------- > 1 3 > > Shouldn't these two queries produce the same results? > > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam protection around > http://mail.yahoo.com > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
