search

kashipai / h2database

H2 Database for reference.
0 stars 0 forks source link

Support USING clause for JOIN conditions #423

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
Please add support for the USING clause for JOIN conditions, as specified in 
the SQL-92 standard. The USING clause makes it easier to write joins for tables 
with shared column names for the primary key and foreign key. For example:

  SELECT department_id
  FROM employees
  JOIN departments USING (department_id)

It also has the advantage of not needing to qualify the join column. If the 
above example was a LEFT join, then department_id would refer to the value of 
the inner table (and thus not be NULL in cases where the join doesn't match).

Original issue reported on code.google.com by electrum on 24 Oct 2012 at 8:44

GoogleCodeExporter commented 9 years ago 
Patches are welcome. 
Start from the org.h2.command.Parser class.

Original comment by noelgrandin on 12 Dec 2012 at 7:57

GoogleCodeExporter commented 9 years ago

Original comment by noelgrandin on 6 Mar 2013 at 5:06