Learn how to rotate a table to present the one to many relation between two tables as a one to one relation and present all the matching records in a single row.

This story continues at http://www.databasejournal.com/featu...le.php/3689491