It might be worth doing some of this work with an ORM (Object Relation Mapper). Almost all higher level languages have them. Once you get things configured, the messiness of the joins is hidden behind syntactic sugar.
Here is a comparison of a lot of them from wikipedia. http://en.wikipedia.org/wiki/Comparison_of_object-relational_mapping_software SQLAlchemy is a market leader for python. If you are a microsoft shop, I understand LINQ us really nice. http://en.wikipedia.org/wiki/Language_Integrated_Query#LINQ_to_SQL On Wed, Nov 9, 2011 at 1:34 PM, George Gallen <ggal...@wyanokegroup.com> wrote: > I'm in the process of creating/updating a MySQL database for external > applications to analyze some of the data. > > My initial method of dealing with a multivalued field, is to create it's own > table, keyed to the master table (1:n) > But this gets a little tedious if you have a bunch of multivalued fields - > and creates really bulky SQL statements with all the joins. > > What other ways are people using to work with 1:n relationships? > _______________________________________________ > U2-Users mailing list > U2-Users@listserver.u2ug.org > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users