zOs/SQL/BINDHISL

select pgm, g.genId, seq, line, g.*
    from oa1p.tQZ043BindGen g
      left join oa1p.tQZ044BindLine l
        on g.genId = l.genId
      where pgm = 'MF5000'
    order by genTst desc, genId, seq