✅ The verified answer to this question is available below. Our community-reviewed solutions help you understand the material better.
¿Qué parte de la siguiente sentencia SELECT genera un error?
SELECT a.apellido || ', ' || a.nombre as "Paciente",
b.apellido || ', ' || b.nombre as "Médico", c.admision
FROM pacientes a
JOIN medicos b ON (b.idMedico = c.idMedico)
JOIN admision c ON (a.idPaciente = c.idPaciente);