Hi All,
I tried to create the session.CreateQuery for joining multiple tables as below:

select distinct pd from ProfileDevice pd ,
AssociationDevice ad, ProfileOwnership os
left join fetch pd.customer
where ad.device.id = pd.id
and os.profileOwnershipKey.enterpriseId = pd.enterpriseId
and (ad.association.id = ? )
and ( pd.imei = ? or pd.did= ? or os.ownership = ?)
and ad.association.id in (:IDS)

But session.createQuery API didn't like it. Do you have any ideas what was wrong here.