[thelist] SQL Madness! Many-to-many selection

J. Blanchard jay.blanchard at thermon.com
Fri Aug 17 16:16:57 CDT 2001


I find that creating an intermediate table that has a one to many relationship to each of the tables in the many to many relationship helps and will be quicker when processing the query. You can use triggers to automatically update the intermediate table when other actions are performed on the other tables.

Just a late Friday afternoon thought...

Jay Blanchard
Web Development Manager
Thermon Manufacturing Company
1.800.820.HEAT x327
___________________________________________________________________________
Visit http://www.visto.com.
Find out  how companies are linking mobile users to the 
enterprise with Visto.





More information about the thelist mailing list