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...
PK, Title, Text, Date
PK, FK-C, FK-A