data Type conflict in join while creating view

Hi All,

I am creating view on 2 tables. But the fields that i am using to join 2 tables have different data elements and different data type.

I am getting error "Type conflict in join (Two fields with different data types or lengths)"while activation .

I cant make dataelements same since tables are standard.

Can you please help.

Thanks

Savio