SELECT x.*,(select ypmlbz from bm_yd0000 where ypnm00=x.ypnm00) ypmlbz
,(select GJBZBM from bm_yd0000 where ypnm00=x.ypnm00) GJBZBM
,(select GJBZMC from bm_yd0000 where ypnm00=x.ypnm00) GJBZMC 
 FROM YK_YPRKMX x
WHERE x.RKDH00='062062'
ORDER BY x.YPRKPC