low, you’re getting a basic subquery error – research how to fix that.
> Mike
>
>
>
> *From:* aditya desai
> *Sent:* Thursday, April 08, 2021 4:32 AM
> *To:* Pgsql Performance
> *Subject:* str_aggr function not wokring
>
>
>
> Hi,
>
> I need to combine
o:* Pgsql Performance
> *Subject:* str_aggr function not wokring
>
>
>
> Hi,
>
> I need to combine results of multiple rows in one row. I get below error.
> Could you please help.
>
>
>
> Query:
>
>
>
> select string_agg((select '*
From: aditya desai
Sent: Thursday, April 8, 2021 1:32 PM
To: Pgsql Performance
Subject: str_aggr function not wokring
Hi,
I need to combine results of multiple rows in one row. I get below error. Could
you please help.
Query:
select string_agg((select '**' || P
Hi,
I need to combine results of multiple rows in one row. I get below error.
Could you please help.
Query:
select string_agg((select '**' || P.PhaseName || ' - ' ||
R.Recommendation AS "ABC" from tblAssessmentRecommendation
R,tblAssessmentPhases P
where R.PhaseID = P.PhaseID Order BY P.sor
