zOs/SQL/MFJOIN

select current timestamp from sysibm.sysdummy1;
select t.part, t.mf150023, t.mf150013
    from A540769.tmfnvhash t
    where t.part <> ( select t.part
        from A540769.tmfnvpart p
        where t.mf150hash between p.von and p.bis)
;
select current timestamp from sysibm.sysdummy1;
    and (t.part <> p.part or t.part < 0 or t.part > 11047)
    order by t.part                  asc,
             t.MF150023              ASC,
             t.MF150013              DESC
    with ur
;