Ok, I suspect the problem is to do with my query. It's returning results like this:
username | authority | description | authority Maarten | ROLE_CUSTOMER | SPECIAL | ROLE_MANAGEMENT Maarten | ROLE_CUSTOMER | SPECIAL | ROLE_XYZ Maarten | ROLE_VISITOR | SPECIAL | ROLE_MANAGEMENT Maarten | ROLE_VISITOR | SPECIAL | ROLE_XYZ And I think I need it to return results like this: username | authority | description | authority Maarten | ROLE_CUSTOMER | | Maarten | ROLE_VISITOR | | Maarten | | SPECIAL | ROLE_XYZ Maarten | | SPECIAL | ROLE_MANAGEMENT So it's probably now more of an SQL question. -- View this message in context: http://www.nabble.com/Outer-Join---Mapping-More-Than-One-tp25530776p25531012.html Sent from the iBATIS - User - Java mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-java-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
