Hello,

I´m using JPA and i can´t translate this SQL query in to HQL


select
atleta.Nome as nome,
graduacao1.data as dataInsc,
tipogradua.nome as grad
from
judo.Atletas atleta,
judo.TiposGraduacoes tipogradua,
judo.Graduacoes graduacao
left join judo.Graduacoes graduacao1
on (graduacao.indice_atleta=graduacao1.indice_atleta and graduacao1.id_tipo_graduacao=1)

where
graduacao.indice_atleta=atleta.indice_atleta
and graduacao.id_tipo_graduacao=tipogradua.id_tipo_graduacao
and graduacao.id_doc=145


The problem is that i can´t make an left join from a entity Graduacoes to an Entity Graduacoes.

Help is appreciated

Thanks in advance
Nuno Silva

I don't think you can do an outer join if the entities are not related in their mappings. You might have to break this into two queries.



Farzad-