I just found a better query for what I need, but i...
# komapperd
dave08
03/04/2024, 1:23 PMI 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 PMSpecifying 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 PMYeah, 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