Multiple Joins to a Single Table - MsAccess

The are some scenarios in #relational #database design where you need to design multiple independent #foreign-key relations between just two #tables. When you want to create a #query to retrieve the data from these tables, you must create multiple #joins to a single table.
Sounds complicated? It becomes much less complicated once we look at a concrete example of this scenario in Microsoft #Access in this video.