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?