SELECT A.* 
           ,B.htl_name
           ,D.room_name
FROM RS_HMST A
INNER JOIN HT_MST B ON A.ht_mst_seq = B.ht_mst_seq
INNER JOIN RS_HROOM C ON A.rs_hmst_seq = C.rs_hmst_seq
INNER JOIN HT_ROOM_INFO D ON C.ht_room_info_seq = D.ht_room_info_seq
WHERE A.rs_hmst_seq = :rs_hmst_seq
LIMIT 1