Advertisement
Guest User

Untitled

a guest
Oct 19th, 2017
195
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.     SELECT PASSENGER.P_ID
  2.     FROM PASSENGER, BOOKING
  3.     WHERE PASSENGER.P_ID = BOOKING.P_ID(+) AND BOOKING.BOOKING_DATE IS NOT NULL
  4.     GROUP BY PASSENGER.P_ID
  5.     ORDER BY PASSENGER.P_ID;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement