Strict Match on Many-to-One Relationships in Lookup Tables Using SQL

How to Use SQL Joins and Aggregation Techniques for Data Retrieval with Multiple Detail Rows