I need to find PORTFOLIO ID and NAME for Investment, i'm trying to map INV_INVESTMENT to PFM_INVESTMENTS to get the details from PFM_PORTFOLIOS. i'm getting "too many rows" error due to more than one portfolio for one investment
can you please suggest me a way to solve it.
(select distinct pma.name,pma.id
inner join PFM_PORTFOLIOS pma on pmac.portfolio_id = pma.id
inner join inv_investments inv on pmac.investment_id=inv.id