>Why would you change that? The first JSON subquery correlates to the outer >query via f.film_id
Ah … ok … I see, f is from the outer query .. yep, I got it. Thanks again 🙏 Dominik > Am 23.02.2022 um 21:32 schrieb [email protected]: > > [email protected] > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/jooq-user/topics> > Google Groups > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> > > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email/#!overview> > > Topic digest <> > View all topics > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/jooq-user/topics> > Digest for [email protected] - 2 updates in 1 topic > <x-msg://2/#group_thread_0> - 2 Updates > <>Digest for [email protected] - 2 updates in 1 topic > <http://groups.google.com/group/jooq-user/t/bbb6c0ac418e1596?utm_source=digest&utm_medium=email> > > Dominik Hirt <[email protected]>: Feb 23 12:13PM +0100 > > 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 23 12:26PM +0100 > > 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 < > Back to top <x-msg://2/#digest_top> > You received this digest because you're subscribed to updates for this group. > You can change your settings on the group membership page > <https://groups.google.com/forum/?utm_source=digest&utm_medium=email#!forum/jooq-user/join>. > To unsubscribe from this group and stop receiving emails from it send an > email to [email protected] > <mailto:[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/117AD679-2D61-4D4A-8E45-1E85ABD0BD31%40googlemail.com.
