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