There is Hibernate mapping created for this structure.
Three tables are created for this mapping
Now I want to fetch Child object where I have parent object with me.
Query in simple SQL is
select * from tbl_child tc inner join tbl_lstChild tlc on
tc.id=tlc.child_id where tlc.id=123
Above query is working fine.
Now How do I write same query in Hibernate(HQL)?
Please hel me