select a.*,d.dwmch from fr_spkfk0819 a
join spkfk b on a.商品編号=b.spbh
left join (select dwbh,spid,row_number() over (partition by spid order by plh) row from spls_rk) c on b.spid=c.spid and c.row=1
left join mchk d on c.dwbh=d.dwbh
select a.*,d.dwmch from fr_spkfk0819 a
join spkfk b on a.商品編号=b.spbh
left join (select dwbh,spid,row_number() over (partition by spid order by plh) row from spls_rk) c on b.spid=c.spid and c.row=1
left join mchk d on c.dwbh=d.dwbh