SELECT A.*
          , B.title_2 as title
FROM RA_DISP A
INNER JOIN  RA_DISP_TITLE B ON A.ra_mst_seq = B.ra_mst_seq AND A.disp_no = B.disp_no
WHERE A.ra_mst_seq = :ra_mst_seq
AND A.disp_no = :disp_no
AND A.disp_yn = 'Y'
ORDER BY sort_idx ASC