Is there a "raw data" mapping that might work with following scenario. I have a company entity that serves various industries. So there would be a company table and a simple industry table that contains an ID
and the industry name - just two fields.Each company can serve many industries and different companies can serve the same industry.
So there is effectively a many-to-many relationship. Is it possible to have a many to many that just looks at the raw data in the industry table? As opposed to having an industry domain object - its just a simple lookup to get a collection of Strings for the industries served in the two column Industry table?I'm assuming this will be defined as a many-to-many mapping. Thanks for any assistance.

I am using MYSQL,Hibernate 2.1.