Concatenate column results?

[hapax]

Is there a SQL command to concatenate column results? Here's what I mean - I have SQL that produces this:

SUBSCRIBER LOCATION DESCRIPTION
------------- ------------ ---------------------------------
2017 327 Infrastructure
2017 327 Internet Basic
2017 327 Video Basic

Since the subscriber and location are the same, it would be great to get output something this instead, with the description showing the combined data:

SUBSCRIBER LOCATION DESCRIPTION
------------- ------------ ---------------------------------
2017 327 Infrastructure, Internet Basic, Video Basic

 

[Golom]

Not in ANSI SQL (which this forum is).

I believe that mySQL has an SQL extension that does it and in Access you can write a function for that purpose.

Probably better to ask this question in the forum for the DBMS you are using.

 

[emblem]

Hi,

See forum TT1177-1465286 for your answer, if using Oracle

good luck,
emblem