>I have two free tables that I want to join in a view. TABLE1 has a CATALOG field that is 6 characters long (eg AE001H). TABLE2 has a CATALOG field that is 5 characters long (eg AE001).
>
>For example...TABLE1 may have the following records:
>
>AE001H
>AE001S
>AE001L
>AE002H
>AE003S
>etc.
>
>TABLE2 has only
>AE001
>AE002
>AE003
>
>In otherwords, I want the relationship between TABLE1 and TABLE2 to be based on SUBSTR(TABLE1.CATALOG,1,5)
>
>How do I accomplish this in the View Designer?
No extra function is needed :
create sql view myview as ;
select * from table1 ;
inner join table2 ;
on table1.catalog = table2.catalog
Cetin