Ok, thanks! I'll try this workaround! Roberto Barra
On 16 nov, 15:30, Thomas Mueller <[email protected]> wrote: > Hi, > > Thanks for your mail! This case is not working yet as expected. I'm > trying to fix it. As a workaround, you could use explicit nesting > using (): > > select > units.id > from > prj_obs_units units > left outer join (cmn_captions_nls valsObsTipoFase > join cmn_lookup_types ltObsTipoFase > on ltObsTipoFase.id = valsObsTipoFase.pk_id) > on valsObsTipoFase.table_name = 'CMN_LOOKUP_TYPES' > > left outer join (cmn_captions_nls valsObsFase > join cmn_lookup_types ltObsFase > on valsObsFase.pk_id = ltObsFase.id) > on valsObsFase.table_name = 'CMN_LOOKUP_TYPES' > where > units.id = 5003736 > > Regards, > Thomas -- 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.
