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

SQL outer join one table with 2 tables

Language: Layout:
absolute service time: 0,37 sec 
edit mode |  history 
  
personId
personName
childId
childName
friendId
friendName



1
1
joe
1
frank
NULL
NULL



2
1
joe
2
dan
NULL
NULL



3
1
joe
NULL
NULL
1
will



4
1
joe
NULL
NULL
2
bob






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development