Hi. Is it possible to have a one-to-many relationship by defining the many table to have more than one key that defines a row as a child of another table? In other words, if I have a Teacher table like this:
SCHOOL_CD TEACH_CD TEACH_FNAME TEACH_LNAME
-------------------------------------------------------------------------------------------------------------
10 105 Henry Jones
and a student table
SCHOOL_CD TEACH_CD STUDENT_FNAME STUDENT_LNAME
-----------------------------------------------------------------------------------------------------------------
10 100 John Smith
10 105 Roland Jones
I'm looking to only have Roland Smith returned for where the the SCHOOL_CD = 10 AND TEACH_CD = 105. Is there some way to define this in the mapping.xml?
I'd appreciate and help.
Isaac
