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
WHERE fa.actor_id = a.actor_id
With this both changes, the statement can be executed.
> 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,
> 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