Dear All

I have a question regarding HQL as below.


Customer:Contact is 1:1
Contact:Address is 1:n
Address:PhoneAdress is 1:1
Address:PostAddress is 1:1
PhoneAddress.medium is "PHONE"
PostAddress.medium is "MAIL"
PhoneAddress and PostAddress are both subclass of Address

I just need to find Customer who has no PhoneAddress
For example , if a Customer having both PhoneAddress and PostAddress
,then this Customer could not appear in selected Result.
How to create this in HQL?

I already have the working SQL

select c.customer_id from test.customer c
inner join test.contact contact_ on c.customer_id= contact_.contact_id
left outer join test.address a on a.contactaddress= contact_.contact_id and a.medium = "PHONE" where a.address_id is null

But I could not convert this SQL to HQL successfully.
because I fail to left outer join only with Address which is 'PHONE'

Anyone could give me some hints how to convert above SQL to HQL?