Lets say table A has a many to many relationship with table B, and table B has a many to many relationship with C. Two junction tables are created for AB and BC to form the many to many relationships. How would i query these tables so that i can return all the related records between tables A, B, and C?
Is a setup like this a sign of bad design?
Edit: To list my specific issue, I have a table of electronic devices. Each device could have a feature such as wifi, and each feature could apply to that device. Now each feature could pose a security risk, and that same risk could apply to multiple features. So I have many devices, with many features, and many security risks. My goal is to get the results of a question in this form "For each device, show me each feature, and the security risks that it creates".