Data Join with offset

I have below situation: **Table1** Field1 Field2 123 test1 234 test2 **Table2** Field1 Field2 12345 test2 23245 test3 123945 test6 I want to join these two tables i.e. Table1 and Table2 where Field1 of table1 matches with first three characters of field1 of table2. So results here should be: Table1-field1 Table1-field2 Table2-field1 Table2-field2 123 Test1 12345 Test2