Advertisement
Guest User

Untitled

a guest
Sep 19th, 2017
46
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. Select * from participante where not exists (select 1 from matricula where matricula.id_persona = participante.id_persona and matricula.id_actividad=5);
  2.  
  3. @Override
  4. public List<Participante> participantesSinMatriculaEnActividad(int codigoActividad) {
  5. Query query = em.createQuery("SELECT e FROM Participante e WHERE NOT EXISTS (SELECT 1 FROM Matricula m WHERE m.idPersona=e.idPersona AND m.idActividad=?1)");
  6. return query.setParameter(1, codigoActividad).getResultList();
  7.  
  8. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement