"Emil Obermayr" <n...@nobswolf.info> wrote in message news:20090121123739.gc15...@nobswolf.info > 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; > > But I get "SQL error: ambiguous column name: c" > > Can this behaviour be changed?
Can you just write "select a.c from a natural join b;" ? Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
