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 | |