Hi,

I need to join two tables using left outer join. But, the data types of the two tables column are different. I need to know that how to write the hbm files under this situation.


For eg. Consider the following two tables A and B,
Table A(ID NUMBER PKEY,ANOTHER_ID VARCHAR)

Table B(ID NUMBER PKEY,NAME VARCHAR)

I need to left join table A and table B on A.ANOTHER_ID = (CHAR)B.ID

How i need to write the hbm file?

Thanks in advance,
Uday