Run Code  | API  | Code Wall  | Misc  | Feedback  | Login  | Theme  | Privacy  | Patreon 

SQL left join

Language: Layout:
View schema
Execution time: 0.02 sec, rows selected: 6, rows affected: 0, absolute service time: 0.36 sec 
fork 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






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development