Good day! I try to join two tables, but the problem is that the key columns that I want to use (there are no other suitable ones) of different formats. It is clear that you can create a separate process, where you can create a new intermediate table, in which you can format, but in this case the table will not be saved in the repository and then it cannot be stored with the repository, because there may not be enough space in the rack. To solve this problem, I'm trying to use a subquery with the left join. I get syntax errors.
Maybe someone will tell you how to do it correctly and why am I wrong?
Approximately part of the request is as follows
where t1.employee_rk in left join ( select t12.employee_main_num format $11. informat $11., t12.functional from imart.abm_lead_data t12 where t1.functional contains 'INST' ) t13 on (t13.employee.employee_main_num = t1.employee_rk) Thank you in advance!
