Hi. I have tried to do the query using expression constructors and jpql, but jpql does not support subqueryes and then, i am trying to do with nativeQuery. It's possible?
I'm getting an error message. Would anyone know why?
The query is as follows:
The Query at the Console is
It runs in mysql and returns results correctly, but in the class I'm testing the following error occurs: