On Wed, Jan 21, 2009 at 07:40:53AM -0500, Igor Tandetnik wrote: > > Can you just write "select a.c from a natural join b;" ?
Of course, but the DB-application is already written and is used by other DBs also. The application design currently needs the column to be unique without the need to specify the table. According to all the descriptions and documentations I can access, the table-qualifier of a natural-join column is not needed and sometimes even considered a syntax error. What is the statement of the sqlite-developers about that topic? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users