I am using Oracle DB but for unit testing I am using H2 database version 1.4.199. While executing select statement with joins I am getting error message like "Function table3key(+[*]) not found". I suspect it is because of using (+) symbol for joins but I am using Oracle mode so it should support.
Please help me to fix this issue, Thanks! SELECT table1.table1id, table2.table2id, table3.table3id, table4.table4id, table5.table5id FROM table5, table1, table2, table3, table4 WHERE table5.table5id = ? AND table3.table3key = table4.table3key(+) AND table1.table1key = table2.table1key(+) AND table2.table2key = table3.table2key(+) -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/13f60178-8f77-4ea9-b0dd-b58a154e5591n%40googlegroups.com.