Query from multiples domains in grails

See more:

Groovy

I have issues. Please help me I you can.

I have 3 domains called:

- DomainA(id, propA1,propA2)
- DomainB(id, propB1,propB2,forgeinKeyToDomainA)
- DomainC(id, propC1,propC2,forgeinKeyToDomainB)

The relationship of domains is:

DomainA hasMany DomainB, DomainB beLongsTo DomainA
DomainB hasMany DomainC, DomainC beLongsTo DomainB

I wants to get all record from DomainC that propA1="value1"

Imaging SQL code:

Select DomainC.* 
from DomainA,DomainB,DomainC
where DomainA.id=DomainB.forgeinKeyToDomainA
and DomainB.id=DomainC.forgeinKeyToDomainB
and DomainA.propA1="value1"

I can executing SQL code in grails, but I wants to use Hibernate.

Thanks.