Created
April 21, 2018 23:43
-
-
Save GreyHat147/a40bc869cbd07f379befd1927271ce85 to your computer and use it in GitHub Desktop.
vista
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
CREATE VIEW vista1 as SELECT | |
socios.nombre as nombresocio, | |
cursos.deporte, | |
cursos.dia, | |
profesores.nombre as nombreprofesor, | |
inscriptos.matricula | |
from socios, cursos, profesores, inscriptos | |
where socios.documento = inscriptos.documentosocio AND profesores.documento = cursos.documentoprofesor; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment