joining of two files

Hi,


I have two files lets say file1 and file2.

file1 has multiple fields but let's say currently we are just focused for
it's field1 and similarly file2 have multiple such fields and we are just
concerned with field2.

field1 of file1 is of packed decimal with 6 length.

field2 of file2 is of character data type and of length 9.

Now we want to join file1's field1 to the fiel2's field2 in such a way that
we are sure that field2 (would have that matching value from file1's field1
in it's( inside field2) first 6 positions only.
and even if it's found in field2 beyond 6th position then we are not
concerned with that match.

So how to join these files to get the matching records from fiile1's field1
to file2's field2.

I mean what should be the join SQL query to get these matching records?



Thanks