Re: Digest for jooq-user@googlegroups.com - 2 updates in 1 topic

11 views
Skip to first unread message

Dominik Hirt

unread,
Feb 23, 2022, 6:13:52 AMFeb 23
to jooq...@googlegroups.com
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 <lukas...@gmail.com>: 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 'tod...@googlemail.com' 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 jooq-user+...@googlegroups.com.

Lukas Eder

unread,
Feb 23, 2022, 6:26:33 AMFeb 23
to jOOQ User Group
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)

--
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 jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/1EF3BA4E-9127-49F3-8AED-DD3728DA424C%40googlemail.com.

Dominik Hirt

unread,
Feb 24, 2022, 5:48:22 AMFeb 24
to jooq...@googlegroups.com
>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 🙏


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 <lukas...@gmail.com>: 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 <
Reply all
Reply to author
Forward
0 new messages