RE: str_aggr function not wokring

I need to combine results of multiple rows in one row. I get below error. Could you please help.

Query:

Error:

ERROR: more than one row returned by a subquery used as an expression SQL state: 21000

Regards,

Aditya.

Hi,

I would suggest you to try something like this instead

select string_agg( '******' || P.PhaseName || ' - ' || R.Recommendation ''  ORDER BY P.sortOrder DESC ) AS "ABC"

from tblAssessmentRecommendation R,tblAssessmentPhases P

where  R.PhaseID = P.PhaseID 

Regards,

Patrick