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? Will it be changed in the future? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users