All pastes #336865 Raw Edit

Unnamed

public text v1 · immutable
·published 2007-02-02 09:57 UTC
rendered paste body
table "a"

name month  people
1      1    10 
1      2    12  
1      3    13
2      1    2
2      2    2
2      3    1
1      4    15
1      5    16

this is the content of the table - "a"

now i need a query to display 

name month people
1      1    10
1      2    12
1      3    13
1      4    15
1      5    16
2      1    2
2      2    2
2      3    1
2      4    0
2      5    0

ie for a particular name . if there is no month value for it. it shd shd show the month and and its value as 0

pls tell me how to do it?.