I have the following SQL query:
select c.id
from (select id from customers) c
This query has no practical value – I simplified it greatly for the purpose of this post.
My question: is it possible have a subquery in the from clause using HQL. If not, can I perhaps query the customers first, kinda like a temp table in sql, and then use the result as the source of the next query?
thanks
Best Answer
Yes, it's possible.
The query above can be written in HQL as: