Advertisement
Guest User

Untitled

a guest
May 5th, 2021
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.47 KB | None | 0 0
  1. SELECT P1.*
  2. FROM PERSONA P1,
  3. INVENTOR I1,
  4. EMP_PER E1
  5. WHERE EMP_PER.DNI = PERSONA.DNI
  6. AND INVENTOR.DNI_INVENTOR = PERSONA.DNI
  7. AND (SELECT COUNT(A2.*)
  8. FROM EMP_PER E2,
  9. PERSONA P2,
  10. AYUDANTE A2
  11. WHERE AYUDANTE.DNI-INVENTOR = I1.DNI-INVENTOR
  12. AND P2.DNI = A2.DNI-AYUDANTE
  13. AND E2.DNI = P2.DNI
  14. AND E2.CODIGO <> E1.CODIGO ) > 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement