inner query in hibernate

[pankaj semwal]

Hi List[],
I have below query.How can i write the query using HQL or Criteria .Please tell me.

SELECT this_.mpim_cmpn_no AS mpim1_5_0_, this_.mpim_corp_no AS mpim2_5_0_,
       this_.mpim_part_no_frm AS mpim3_5_0_,
       this_.mpim_part_no_to AS mpim4_5_0_, this_.mpim_emp_no AS mpim5_5_0_,
       (SELECT cdmst_code_descp
          FROM cmcdmst_tb
         WHERE cdmst_group_name = 'HRMDL'
           AND cdmst_code_id = this_.mpim_model_code) model,
       this_.mpim_valid AS mpim7_5_0_, this_.mpim_valid_from AS mpim8_5_0_,
       this_.mpim_valid_to AS mpim9_5_0_,
       this_.mpim_crte_dtime AS mpim10_5_0_,
       this_.mpim_crte_emp_no AS mpim11_5_0_,
       this_.mpim_upt_dtime AS mpim12_5_0_,
       this_.mpim_upt_emp_no AS mpim13_5_0_,
       fnc_get_emplyee ('H',
                        'A10AA',
                        'A10AA',
                        this_.mpim_emp_no
                       ) AS formula0_0_
  FROM rempim_tb this_

Thanks & Regards
Pankaj

[Wouter Oet]

What was your attempt? And who is List[]?

[pankaj semwal]

i tried using HQL like this

               MPIM_PART_NO_FRM, MPIM_PART_NO_TO, MPIM_EMP_NO, MPIM_VALID_FROM ,mpim_model_code , (cdmst_code_descp from 
 cmcdmst_tb  
          WHERE cdmst_group_name = 'HRMDL'  
            AND cdmst_code_id = mpim_model_code)
)  model
    FROM REMPIM_TB 

But its did not working and throwing exception.

SO is any other way in hibernate to run this sql using HQL or Criteria.

By the way List[] mean the people of java ranch ........