On Tue, Feb 22, 2011 at 14:17, Richard Hipp <d...@sqlite.org> wrote: > > The query is really more like this: > > SELECT DISTINCT COALESCE(a.xxx, b.value) value > FROM tbl1 a > LEFT OUTER JOIN tbl2 b > ON a.zzz = b.ttt > WHERE value NOT IN ( > SELECT DISTINCT ggg > FROM tbl3 > ); > > The "value" on the left-hand side of the NOT IN operator is ambiguous: Does > it refer to the first column of output or to the "value" column of the "b" > table? SQLite chooses the latter.
Thank you for your answer. Benoit _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users