SELECT m.force, m.surname, m.init, a.id,
   NVL(a.qualification_name_not_found, b.qualification_name) qual_name,
   q.qualcode, m.app_cde,
   r.description AS rank
FROM locnavy.MEMBERS m,
   nlrd.QUALIFICATION_ENROLMENT a,
   nlrd.MASTER_QUALIFICATION b,
   JOB_QUAL_LNK c,
   RANKS r,
   JOB_QUALIFICATION q
WHERE a.id = m.force
   AND r.rank_id = m.rank_cde
   AND a.qualification_id = b.qualification_id (+)
   AND a.qualification_id = c.qualification_id
   AND a.learner_achievement_status_id IN (2,32)
   AND c.job_qualification_id = q.job_qualification_id"
   AND q.qualcode != 'XXX'
   AND (m.mustering_cde = '" + mustCode + "' OR '"+ mustCode +"' IS NULL)
   AND (m.rank_cde = '" + rankCode+ "' OR '" + rankCode+ "' IS NULL)
   AND NVL(m.STATUS,'A') = 'A' AND m.app_cde IN ('MC','MG','MP','PE','PF','PV')

QUALIFICATION_ENROLMENT
MASTER_QUALIFICATION
JOB_QUAL_LNK
RANKS
JOB_QUALIFICATION

<class
      name="pruebahibernate_1.AparatoYConf"
      table="TIPOS_APARATO">
        <id
         name="idtaparato"
         column="id_t_aparato">
        </id>
      <property
         name="descripcion"
         column="DESCRIPCION"/>
        <join table="TIPOS_APARATO_CONF">
            <key column="id_t_aparato"/>
            <property name="fdesdetap" column="f_desde_tap"/>
            <property name="fhastatap" column="f_hasta_tap"/>
            <property name="codcne" column="cod_cne"/>
        </join>
    </class>

SELECT A.id_t_aparato, descripcion, f_desde_tap, f_hasta_tap, cod_cne
        FROM TIPOS_APARATO A, TIPOS_APARATO_CONF B
        WHERE A.id_t_aparato=B.id_t_aparato