Run Code  | Code Wall  | Users  | Misc  | Feedback  | About  | Login  | Theme  | Privacy 

SQL left join

Language: Editor: Layout:
View schema
Execution time: 0.02 sec, rows selected: 6, rows affected: 0, absolute service time: 0.36 sec 
edit mode |  history  | discussion
   ID From To Departure_date Planes_ID
1 1 Vilnius Berlin 3/1/2012 4:00:00 PM 1
2 2 New York Los Angelos 5/1/2012 3:30:00 PM 2
3 3 Chicago Tokyo 7/1/2012 9:00:00 PM NULL
   From To Departure Date Plane Model Seats
1 Vilnius Berlin 3/1/2012 4:00:00 PM Boeing 777 300
2 New York Los Angelos 5/1/2012 3:30:00 PM Boeing 787 Dreamliner 310
3 Chicago Tokyo 7/1/2012 9:00:00 PM NULL NULL