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
and I need to build a select that would return to me something like ;
4 Chandler / Cussler / Smith
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