Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT V1.IdVolo, V1.IdAArrivo, V2.IdVolo AS IdProssimoVolo
- FROM Voli V1 JOIN Voli V2 ON (V1.IdAArrivo = V2.IdAPartenza AND V1.Giorno = V2.Giorno)
- WHERE V2.Ora > V1.Ora AND NOT EXISTS (
- SELECT *
- FROM Voli V3
- WHERE V3.Giorno = V2.Giorno
- AND V3.IdAPartenza = V2.IdAPartenza
- AND V3.Ora < V2.Ora
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement