On Wed, Jan 21, 2009 at 01:37:39PM +0100, Emil Obermayr wrote: > I am not sure what the standard says, but I am used to single columns > after a natural join. So if table a and b are joined through column c > the following statement is valid: > > select c from a natural join b;
bad example, because actually it works with 2 tables is does not with 3 tables without brackets: sqlite> select x from a natural join b natural join c; SQL error: ambiguous column name: x same with brackets: sqlite> select x from a natural join (b natural join c); 1 2 Might be related to Ticket 1217; I added a remark there. I guess this is still a little fault in the parser? Emil _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
