[prev in list] [next in list] [prev in thread] [next in thread] 

List:       ojb-user
Subject:    Re: left outer join
From:       Jakob Braeuchi <jbraeuchi () gmx ! ch>
Date:       2004-05-29 15:16:12
Message-ID: 40B8A93C.3030203 () gmx ! ch
[Download RAW message or body]

hi dean,

what exactly does not work ?
could you please post the generated sql ?

jakob

Dean Tanabe wrote:

> hi i've been trying to perform the outer join as per examples and other messages \
> here, but I can't seem to get it to work.  Just wondering if anyone could help me \
> out. 
> Criteria criteria = new Criteria();
> criteria.addEqualTo("logEntries.userId", userId);
> ReportQueryByCriteria query = QueryFactory.newReportQuery(ExperienceTypeVO.class, \
> criteria); query.setAttributes(new String[] { "experienceId", \
> "sum(logEntries.experienceCount)" }); query.addGroupBy(new String[] { \
> "experienceId" }); query.setPathOuterJoin("logEntries");Much thank,Dean
> 		
> ---------------------------------
> Do you Yahoo!?
> Friends.  Fun. Try the all-new Yahoo! Messenger

---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]