Why would you change that? The first JSON subquery correlates to the outer query via f.film_id (where f is from the outer query)
On Wed, Feb 23, 2022 at 12:13 PM 'Dominik Hirt' via jOOQ User Group < [email protected]> wrote: > Hi Lukas, > > thanks for your response. > That was also was my first idea, but in this case, also the WHERE > condition has to be fixed from > > WHERE fa.film_id = f.film_id > into > WHERE fa.actor_id = a.actor_id > > With this both changes, the statement can be executed. > > > Kind regards > Dominik > > > Lukas Eder <[email protected]>: Feb 22 08:19AM +0100 > > > > Thanks for your message. Yes of course, there's a wrong table alias here: > > > > JOIN actor AS f > > > > It should be: > > > > JOIN actor AS a > > > > I added the aliases for readability purposes. The actual query generated > by > > jOOQ doesn't alias the tables > > > > Best Regards, > > Lukas > > > > On Mon, Feb 21, 2022 at 11:04 PM '[email protected]' via jOOQ User > > Back to top > > You received this digest because you're subscribed to updates for this > group. You can change your settings on the group membership page. > > To unsubscribe from this group and stop receiving emails from it send an > email to [email protected]. > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/1EF3BA4E-9127-49F3-8AED-DD3728DA424C%40googlemail.com > . > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO7qegiLE7Y588jL8R0by3z0XgOeg0wG7WkiYuMOyRcCOg%40mail.gmail.com.
