Cannot use a subquery in the FROM clause in JPQL
I was doing a subquery in JPQL with a FROM clause without using a nativeQuery, but for some reason I got an error.
It seems that JPQL does not allow subqueries with FROM clause.
It seems that subqueries are possible in the WHERE and HAVING clauses.
The only solution seems to be to use nativeQuery.