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

Getting one row of data pr month even though there is no data for that

Language: Layout:
View schema
Execution time: 0,02 sec, rows selected: 24, rows affected: 6, absolute service time: 0,16 sec 
edit mode |  history 
  
Salesman
Yr
Mnth
Sales



1
A
2017
1
15



2
A
2017
2
0



3
A
2017
3
0



4
A
2017
4
0



5
A
2017
5
25



6
A
2017
6
0



7
A
2017
7
0



8
A
2017
8
0



9
A
2017
9
0



10
A
2017
10
0



11
A
2017
11
0



12
A
2017
12
0



13
B
2017
1
0



14
B
2017
2
0



15
B
2017
3
0



16
B
2017
4
20



17
B
2017
5
0



18
B
2017
6
49



19
B
2017
7
0



20
B
2017
8
0



21
B
2017
9
0



22
B
2017
10
0



23
B
2017
11
0



24
B
2017
12
0






    
                		
                
                    

                          
                                
                                
                        
                         



                        
                        
                        

                        

                        
                        

                          
                                
                                
                                  

                                    
λ

                                    

                                      .NET NoSQL database for rapid development