This may be related to my previous post about the NATURAL JOIN syntax... I noticed that the JOIN USING(column [, column...]) syntax is currently not supported by H2. This syntax is a useful compromise when users want to "natural join" two tables without giving full control to the database. There is some interesting feedback on this topic, here on Stack Overflow:
http://stackoverflow.com/questions/3277580/sql-server-lack-of-natural-join-x-join-y-usingfield In any case, the JOIN USING(...) syntax is usually more useful than the NATURAL JOIN syntax. Of course, this would apply to both INNER and OUTER joins. 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.
