I got the following example from old disscussion forum about how to
retrieve by foreign key. I also check 9.7 of doc. But I am still not clear
about how this gonna work.

"FROM foo IN CLASS eg.Foo WHERE foo.bar.id = 666

(The second query is efficient. No table join is required.)"

Here foo and bar has on-to-many relationship, in order to retrieve a set of
bars based on its foreign key. Bu I don't understand what foo.bar.id means exactly. Is "bar" a set of bars defined in Foo class? Thanks.

bar is a <many-to-one>


the query should be written

FROM Foo foo WHERE foo.bar.id = 666

in Hibernate2

Thanks,

I am still not sure about this.
So, here, Foo has many Bars, Bar has a <many-to-one> association with
Foo, right? So, basically, the following query tries to retrieve a Foo using
one Bar's foreign key?

What I want to do is: retrieve a set of Bars based on a given Foo's PK. How
to do this?

If that is all you want then:


from Bar bar where bar.foo.id = ?


(assuming that this is a bidirectional association)