Hi
I have a table like the following

table statefromto with following columns and data
statefrom---------stateto
Unissued Unissued
Unissued Issued
Issued Quoted
Issued Cancelled

What i would like to do is as follows.

It need to be mentioned here that the primary key here is a combination of the the two columns.

What i would to do is when i use load(class,object) where if the statefrom is Unissed it should return me a collection of stateto containing all the rows for Unissed which will basically contain Unissed and Issued.
I want to use lazy and do not want to use HQL.Can anybody help me please on this issue how to define the mapping file to return me a collection bag or list. Thanks in advance.

Gopal Saha