Hi,
Some RDBMS that support the NATURAL JOIN syntax use roughly this SQL
grammar:
NATURAL [ { LEFT | RIGHT } [ OUTER ] | INNER ] JOIN
Example Derby:
http://download.oracle.com/javadb/10.6.2.1/ref/rrefsqljnaturaljoin.html
Example Oracle:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_10002.htm#CHDIJFDJ
H2 only allows for "inner" NATURAL JOINs:
http://www.h2database.com/html/grammar.html#table_expression
I guess, the NATURAL JOIN syntax is a rather low priority. But still,
that might be a nice enhancement to H2...?
Cheers
Lukas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
