select *
from tlb tlb
left outer join tle tle on tle.tle_in_1 = tlb.tlb_ina and tle.tle_lg_1 = tlb.tlb_lpe_u