Skip to content

Instantly share code, notes, and snippets.

@GreyHat147
Created April 21, 2018 23:43
Show Gist options
  • Save GreyHat147/a40bc869cbd07f379befd1927271ce85 to your computer and use it in GitHub Desktop.
Save GreyHat147/a40bc869cbd07f379befd1927271ce85 to your computer and use it in GitHub Desktop.
vista
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