Hi How would I be able to avoid the N+1 selects if I have for example a departments table and a table with employees. All employees belongs to a department and I would like to get a list of department valueObjects where each departmentVo contains a collection of employee valueObjects.
Is it possible to do this with a single select with Ibatis and how would the Sqlmap look like. I am looking for a simple example to get me started. Thank you Magnus
