1. The problem statement, all variables and given/known data I am trying a query on a relational database. No two (related)tables have all the variables/attributes I need. I am trying to do the query on 3 tables. 2. Relevant equations 3. The attempt at a solution Doing a query on 3 tables, I am getting redundancy. No idea what else to do.