1 2 3 4 5 6 7 | SELECT representative_id,firstname,surname,party,house,division_id, portfolio FROM portfolio2representative INNER JOIN representatives ON portfolio2representative.representative_id=representatives.id INNER JOIN portfolios ON portfolio2representative.portfolio_id=portfolios.id |