Hi, please consider the following setup:
create table table_1 ( field_1 number(10) ); create table table_2 ( field_1 number(10) ); insert into table_1 values (1); insert into table_1 values (2); insert into table_2 values (3); insert into table_2 values (4); The following statement orders the elements according to the column in table_1: select * from table_1, table_2 order by field_1; Oracle 10/11 will raise an error (ORA-00918) that the column is ambiguously defined. Is it possible to configure the H2 such that it behaves like Oracle, i.e. not accepting the select statement? Thank you in advance. Best regards, Niko -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To view this discussion on the web visit https://groups.google.com/d/msg/h2-database/-/A84Z7a9Fp_cJ. 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.
