Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT P1.*
- FROM PERSONA P1,
- INVENTOR I1,
- EMP_PER E1
- WHERE EMP_PER.DNI = PERSONA.DNI
- AND INVENTOR.DNI_INVENTOR = PERSONA.DNI
- AND (SELECT COUNT(A2.*)
- FROM EMP_PER E2,
- PERSONA P2,
- AYUDANTE A2
- WHERE AYUDANTE.DNI-INVENTOR = I1.DNI-INVENTOR
- AND P2.DNI = A2.DNI-AYUDANTE
- AND E2.DNI = P2.DNI
- AND E2.CODIGO <> E1.CODIGO ) > 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement