request problem

Flash31186 · **Joined:** Thu Dec 21, 2006 11:01 am **Posts:** 12

Hi all !

I have three tables with one relation one-to-many.
Example :

Enterprise (idEnterprise, Name)
TargetCountry (idEnter, targetCountry)
Country(countryName)

And I would like to query the countries from the enterprise id.
This is the sql request :

SELECT Country.countryName FROM Country, TargetCountry, Enterprise WHERE Country.countryName = TargetCountry.countryName AND TargetCountry.idEnter = Enterprise.idEnterprise AND Enterprise.idEnteprise = 2;

That's it ... I tried to do this request in hql and with a criteria too, but I don't now really for which reason it doesn't work !

Tanks in advance

batmat · **Posted:** Thu Dec 21, 2006 1:11 pm

What do look like your objects? Think about objects to do this query. Something like

Code:

Country yourCountry = (Country)session.createQuery("from Country c inner join c.enterprise").uniqueResult();

(uniqueResult() is an helper method on the session to be used when waiting for one result exactly)