I have this query:
SELECT
Comments
FROM
Interview
WHERE
Profile_ID=[@field:Recruiting_Candidato_ID] AND Job_ID=[@field:Ofertas_Oferta_ID]
The problem is that in the Interview table there are several lines that meet both conditions, then I just dump a line, the oldest data, but I need to dump all fields "comments" that meet the condition.
Thank you very much !!