Hi All,

1) This query returns columns from two tables
2) This query used join condition with two tables.

select m.nbr_mrtg_fm, t.cnt_conv_amtn FROM
mrtg_terms t, mrtg m WHERE
t.id_mrtg = m.id_mrtg AND t.dt_eff_end is null
and t.code_data_srce = 'MID'

This query executed in Rapid sql.

Here tables are
a) mrtg_terms
b) mrtg

Pl give me steps to implement.

Thanks
[/b]

1. you can use the query as is with Hibernate native query support;

http://www.hibernate.org/hib_docs/refer ... rysql.html
2. if your object MortgTerms object has Mrtg field that is mapped as many-to-one then HQL query is simple as

select mt.m.property, mt.property from MortgTerms mt where .....
3. If they are not related in the mapping files then HQL would look almost like SQL.

I suggest going with option #1 and use {EntityName} aliases to use as table names, or if DB schema is stable then simply use table names.

Hi


How about Criteria API with Resctriction??????????