Hi Everyone,

I have this MySQL query that i would like create by using Criteria in Hibernate:

select distinct this_.id as y0, ap.number, ap.account_phone_number_type, p1.number1, p1.type1 from account this_ left outer join account_phone_number ap on this_.id=ap.account_id left join (select this_.id as y1, ap.number as number1, ap.account_phone_number_type as type1 from account this_ left outer join account_phone_number ap on this_.id=ap.account_id where ap.account_phone_number_type="RECEPTION") p1 on this_.id=y1 group by y0 order by p1.number1 desc limit 100;

How is it possible to left join a query in Hibernate?

checking some thing as a test

you can not left join on a query , you can do it on a table.

but you can twist your query to use simple inner join .
example : https://forum.hibernate.org/viewtopic.php?f=1&t=1025421