I have a select that returns the risks (job security) in several lines, I would like the item "T4.RIS_RISCO" to appear in a single line separated by a comma, can anyone help me ??? I have basic knowledge ...
SELECT
T1.ASO_ID,
T1.RIS_ID,
T3.RGR_GRUPO,
T4.RIS_RISCO
FROM
ASO_RISCOS T1
INNER JOIN GRUPO_RISCOS T2 ON (T1.RIS_ID = T2.RIS_ID)
INNER JOIN RISCO_GRUPO T3 ON (T2.RGR_ID = T3.RGR_ID)
INNER JOIN RISCOS T4 ON (T2.RIS_ID = T4.RIS_ID)
WHERE T1.ASO_ID = :ASO_ID
ORDER BY RGR_GRUPO, RIS_RISCO