Hi,


I have this table structure:

C->B->A by foreign keys.

C B A
---- ---- ----
B_id A_id ...

When I load the A object, I want to load all the C's attached to A through B. Is this possible with the current structure? How would I map it?

I could add a many-to-many table to reference A->C->A, but this table doesn't really represent the data.

We are using hibernate 2.1.6.

chuck

Sorry,

it removed the spaces

C
---
B-id

B
---
A_id

A
---
...

chuck