>>No extra function is needed :
create sql view myview as ;
select * from table1 ;

inner join table2 ;
on table1.catalog = table2.catalog<<

Why wouldn't I need to use the SUBSTR function on TABLE1.CATALOG since TABLE1.CATALOG and TABLE2.CATALOG fields are not identical in length?