AnsweredAssumed Answered

One investment will be tagged to different portfolio?

Question asked by Deepannagaraj on Aug 1, 2018
Latest reply on Aug 2, 2018 by Deepannagaraj

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
from
PFM_INVESTMENTS pmac
inner join PFM_PORTFOLIOS pma on pmac.portfolio_id = pma.id
inner join inv_investments inv on pmac.investment_id=inv.id
and inv.id=x.investment_id)

 

Outcomes