delete record from an sql table

Question

Good people I want to delete a record from a table but for that I need to get information from other tables and because of that I am not able to delete.

I basically needed an SQL command that received the patient id from the patient table, via which id_agregado belong to this patient in the table utenteagregado and erased everything belonging to that id_agregado on the table agregado. I’ve tried but all commands give me syntax error.

Thank you

Answer 1

Look if it helps

DELETE FROM AGREGADO
WHERE AGREDADO.ID_AGREGADO IN (
  SELECT utenteagregado.ID_AGREGADO FROM utenteagregado
  WHERE utenteagregado.ID_PACIENTE = ?
)