Not really... Natural joins require that the column names be equivalent on each table. In my current database schema, the common practice is to use <tablename><columnname> as the column name of the FK. (i.e. "CarType" to reference the "Type" column of a "Cars" table)
But yea, what I'm looking for is a form of NATURAL JOIN just..more natural :) -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Monday, September 21, 2009 3:25 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Most wanted features of SQLite ? Shaun Seckman (Firaxis) <shaun.seck...@firaxis.com> wrote: > * I really would like some SQL syntax sugar that will > automatically include rows referenced by foreign keys in a table. I > haven't seen any other SQL database do this as all expect you to > explicitly include the conditions and joins which can become quite the > hassle. Does NATURAL JOIN help? > * My second awesome feature request would be support for storing > prepared statements into the database file to be used at later times. http://www.mail-archive.com/sqlite-users@sqlite.org/msg30073.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
