Beginner's SQL: Many-to-many relationships Support
Many-to-many relationships are all around us. Just think of actors and movies – many actors in one movie, individual actors make many movies. Thus the ability to represent and query such relationships is a crucial part of database operation.
In this article Rudy guides us clearly through the theory of many-to-many relationships before outlining several very common SQL queries you'll need when working with them.
Rudy Limeback
Rudy Limeback is an independent consultant with over 20 years of SQL experience using DB2, SQL Server, Access, Oracle, and MySQL. Rudy is also a Web developer, Technical Editor at Digital Web, one of the original evolt.org admins, with his own Web site since 1996. More information at r937.com. Rudy lives in Toronto, Canada, where the weather allows you to play frisbee golf all year long.