I must to use a queryForObject and no a queryForList
In your setup if you execute:
queryForObject("getMatchList", 5)
it will retrieve single Match object having match_id = 5 with child
matchScores list populated.
if you execute
queryForList("getMatchList", 5)
it will return List containing all Match objects having match_id = 5 with
child matchScores lists populated (i.e. if match_id is unique index the list
will contain single object).
And change your join type in SQL as Engel proposed (to get matchis w/o/
corresponding scores)
