https://kotlinlang.org logo
#komapper
Title
# komapper
d

dave08

03/04/2024, 1:23 PM
I just found a better query for what I need, but it involves using a subquery in a leftJoin... is that possible?
t

Toshihiro Nakamura

03/04/2024, 2:04 PM
Specifying a subquery in the JOIN clause is not supported. If you are using MySQL 8, you can substitute it with CTE. (You are using MySQL 5, aren’t you?)
d

dave08

03/04/2024, 2:06 PM
Yeah, I'm using 5... you have a good memory 😄! Well, I guess I had to use a template... at least you made things much easier with selectAsEntity!
😀 1
2 Views