I have the following problem, I have a table AVALIAÇÃO and another PACIENTE . I need to generate the whole list of evaluations of a particular patient. I already have the query in my datatable that does this, however, I do not know how to display the information of the two tables, since on one side I have all the patient information and on the other I can have several records of evaluations, that is, I will have to use a TABLE for evaluation in the report and another TABLE or TEXTBOX to display the patient data.
VALUE datatable Query:
SELECT avaliacao.*, paciente.* FROM avaliacao a INNER JOIN paciente p ON a.idpaciente = p.id WHERE p.id = @p