Advertisement
Guest User

Untitled

a guest
Jul 2nd, 2017
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT *
  2. FROM Linea l
  3. WHERE NOT EXISTS (SELECT *
  4.           FROM Parada p
  5.           WHERE NOT EXISTS (SELECT *
  6.                     FROM Abordaje a, Viaje v, Circuito c
  7.                     WHERE a.Id_Viaje = v.Id_Viaje AND a.Cod_Parada = p.Cod_Parada AND a.Tipo_Abor ='Trasbordo' AND
  8.                                            l.Nro_Linea = v.Linea AND a.Cod_Parada = c.Cod_Parada AND c.Nro_Linea = l.Nro_Linea
  9.                                     )
  10.            );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement