Query SQL to table with several values that meet conditions

0

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 !!

    
asked by Laura Comesaña 20.11.2018 в 17:34
source

0 answers