Hello,
I have a Users table then a Claim table. The Claim table links to the
User table many times. For instance: cleric_id, doctor_id,
pricer_id ... all of those are different users performing well
defined roles with the claim. I know how to link 1 of them via a
SqlMap. I have a resultSet defined but it's field names are like:
USER_ID, USER_CODE, USER_FIRST_NAME, USER_LAST_NAME.
How can I handle mapping CLERIC_ID, CLERIC_CODE, ... DOCTOR_ID,
DOCTOR_CODE, ... in one select with out having to create 3 resultMaps ?
Thank you,
Jeremy
