Avatar of Evan Cutler
Evan Cutler
Flag for United States of America asked on

add comma-delineated column into SQL output

I have this SQL:
      SELECT A.PK, A.Title, LEFT(A.Text, 25) + '...', a.date_entered, C.Concentration
      from Advertisements A
      join  [Concentration-Advertisement] CA
      ON A.PK = CA.FK_Advertisement
      join Concentrations C
      ON CA.FK_Concentration = C.PK;

the C.Concentration field lists the field that the Advertisement is associated with.
what happens is rows repeat Advertisement info, because it is a 1 to many ratio.

Instead, I want the C.Concetration to represent a comma-delineated list of the concentrations for one row per advertisement.

Below is the table reference...
Advertisement
============
PK, Title, Text, Date

Concentration-Advertisement
========================
PK, FK-C, FK-A

Concentration
===========
PK, Concentration

Thank you.
Microsoft SQL Server 2008Microsoft SQL Server 2005

Avatar of undefined
Last Comment
Evan Cutler

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
pivar

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Evan Cutler

ASKER
And that's why your the sage :)

Thanks
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23