That is just a simple outer join, then. "*="
Don't work in iBatis, work in a sql query tool and hard code values until you get what you want.
Also long term, "SQL for Smarties" (as opposed to Dummies) is a good book. .V Zoran Avtarovski wrote:
What I need is to retrieve a left join of all list items of a particular type with the relevant m2m values, if present and null if not.
