HQL, left join on the same table
===

I search a way to do a left join with the same table with hql.

It's my query

    select code from Tvshow e
    left join Tvshow e1 on e1.num = e.num
    where e1.code = '024'
    and e.code is not null
    and e.code != '024'
	
Hibernate don't seem to like on operator.