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.
