Hi all;

This mapping gives me the rows which has equal on Table1-"RowIdentity" with Table2-"CommonColumn". values, and works fine:

<bag name="TableTwoList" generic="true" lazy="true" cascade="all" table="TABLE2">
<key column="Table2Column"></key>
<one-to-many class="CommonColumn"/>
</bag>

My problem is: I have "CommonColumn" on my Table1 As well, And I want the rows which has equal value on Table1-"CommonColumn" with Table2-"CommonColumn". How can I do that? Here is the mapping of the column I want to compare:

<property name="CommonColumn" column="CommonColumn" type="Int64"/>