posted 18 years ago
It's really a sql question, not ibatis.
You seem to have a one-to-many relationship, so you don't actually need the mapping table.
However, to list types for an item id you have to join the type table and the item_type table. I'm no sql guru so I'm not sure of the best join syntax, but it's something like:
select ... from type a, item_type b where a.type_id = b.type_id and b.item_id = <some item id>
--Dave