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

Popular posts from this blog

java - Unable to make sub reports with Jasper -

delphi - How to resolve undeclared identifier problems -

Alternative for object pools in cocos2d-x v3.3 -