java - Criteria with full join and left join -
i trying write query using criteria class
select * full join b on a.aid=b.aid left join c on c.bid=b.bid
so far have
criteria = getsession().createcriteria(a.class, "a") .createcriteria("b", "b").createcriteria("c", "c")
which join on inner join not want that
i figured out.
criteria = getsession().createcriteria(a.class, "a", criteria.left_join) .createcriteria("b", "b").createcriteria("c", "c", criteria.left_join); criteria.setresulttransformer(criteria.distinct_root_entity);
Comments
Post a Comment