Hi,

I would like to select all rows  from tables JBPM4_HIST_ACTINST and JBPM4_TASK where   JBPM4_HIST_ACTINST.HTASK_ =JBPM4_TASK.DBID_..

i have used criteria and  detached criteria for this...but i dunno how to select all the rows..so  that i could return it as a List of both the entities 

<class  name="HistoryTaskImpl" table="JBPM4_TASK">
    <id name="dbid"  column="DBID_">
      <generator class="assigned" />
     </id>

</class>

<class name="HistoryActivityInstanceImpl"  table="JBPM4_HIST_ACTINST" discriminator-value="act">
    <id  name="dbid" column=".DBID_">
      <generator class="assigned"  />
    </id>

<subclass  name="HistoryTaskInstanceImpl" discriminator-value="human">
       <many-to-one name="historyTask"
                    class="HistoryTaskImpl"
                   column="HTASK_"
                    cascade="all"
                   foreign-key="FK_HTI_HTASK"
                    index="IDX_HTI_HTASK" />
    </subclass>

</class>