Avatar of npuleio
npuleio

asked on 

a cross join without crossing

Hello everyone!!

I'm trying to cross a select to obtain the result in only one row when there are multiple values; precisely: I have a table with

ID      Author
4       Chandler
4       Cussler
5       King
4       Smith

and I need to build a select that would return to me something like ;

4       Chandler / Cussler / Smith
5       King

and the difficult thing is I don't want to use function like crosstab() in postgresql because once it'll has to go in another platform it has to return the result without problems....

is there a SQL trick to reproduce that result?...

Thanks to all
Ciao
Luigi
PostgreSQLSQL

Avatar of undefined
Last Comment
earth man2

8/22/2022 - Mon