Hello All,

Could someone please help me with following? I have 3 tables where I am joining. I am wondering how to best write hbm and create domain object for it.

Table A
=======
ID
Severity

Table B
=========
ID
Client_Id
Section_Id


Table C
===========
Section_Id
Message

So, that would make my query join where B.ID = A.ID and B.Section_Id = C.Section_Id.

I need to populate a object that will contain following:
Severity, Message.

I believe I know how to setup .hbm however, I am little confused on whats the best way to setup domain object. Should my domain object look like -

FinalObject -
AObject a
BObject b
CObject C

and then also have all three domain objects for each table? Or should I have something like -

FinalObject -
Section_Id
Message


Please help.


Thanks,