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: [email protected] [mailto:[email protected]] On Behalf Of Igor Tandetnik Sent: Monday, September 21, 2009 3:25 PM To: [email protected] Subject: Re: [sqlite] Most wanted features of SQLite ? Shaun Seckman (Firaxis) <[email protected]> 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/[email protected]/msg30073.html Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
