join in hibernate
Posted on 2007-10-19
i am a newbie to hibernate and having problems about join. Image i have two tables like this
create table tbl_master (
create table tbl_detail (
and my query is;
SELECT A.name, B.cusomer_name FROM tbl_master A LEFT JOIN tbl_detail ON (A.id=B.master_id)
how can i implement above sql statment in hql?
is it sensible creating a view an fetching data via this?
could you explain me from scratch?
thanks in advance...