"Emil Obermayr" <[email protected]> wrote in message news:[email protected] > 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
