Hi, There is currently no option to change the behavior in H2. I tried a few databases (HSQLDB, Derby, PostgreSQL), but none supports this feature. So I believe it's better to not support it in H2 as well.
Regards, Thomas P.S. My test case is a bit simpler: DROP TABLE MOVIES; DROP TABLE ACTORS; CREATE TABLE MOVIES (TITLE CHAR(30), RATING INT); CREATE TABLE ACTORS (TITLE CHAR(30), ACTOR CHAR(30)); SELECT M.title, M.rating, A.ACTOR FROM MOVIES M, ACTORS A WHERE M.title = A.title; SELECT M.title, M.rating, A.ACTOR FROM MOVIES M, ACTORS A WHERE MOVIES.title = ACTORS.title; --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
