Try changing to a left join on the match scores table LEFT JOIN matchs_scores ON matchs_scores.match_id =matchs.match_id
-----Original Message----- From: soussou97 [mailto:[EMAIL PROTECTED] Sent: Thursday, November 16, 2006 7:39 AM To: [email protected] Subject: Re: Simple questions Hi Koka; My question is how get a instance of Match having child MatchScore list populated? Normally its a Match object I must to use a queryForObject and no a queryForList ? Koka Kiknadze wrote: > > Well, if you want specific MatchScore object add another query > > <select id="getMatchScoreByID" parameterClass="int" > resultMap="matchScoreResult "> > SELECT * FROM matchs_scores WHERE match_score_id = #value# </select> > > and use queryForObject. > > In your example you get instance of Match having child MatchScore list > populated bu iBatis, i.e. it's for retrieving Match-es not specific > MatchScore-s > > -- View this message in context: http://www.nabble.com/Simple-questions-tf2628323.html#a7376882 Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
