Guest User

Untitled

a guest
Nov 18th, 2017
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. SELECT PELICULAS.*, companias.nombre AS nombreCompania
  2. FROM companias INNER JOIN peliculas ON companias.id_compania = peliculas.id_compania
  3.  
  4. SELECT PELICULAS.*, companias.nombre AS nombreCompania,
  5. DIRECTORES.nombre AS nombreDirector
  6. FROM companias INNER JOIN peliculas ON companias.id_compania = peliculas.id_compania
  7. FROM DIRECTORES INNER JOIN PELICULAS_DIRECTORES ON DIRECTORES.id_director = PELICULAS_DIRECTORES.id_director
Add Comment
Please, Sign In to add comment