Does not do much other than give me a normal join and not returning my locations where there a null value for count. I used the inline query with outer join to counter this but with this i can't get months to also outerjoin and display (in my original posted query).

One way i thought of doing this was generating an inline query that would pair each month with each location and then do the outer join however with over a 1000 locations and 12 months in a year this is not efficient.

Should Look like something like this

Location
1000 Jan-04 1
1000 Feb-04 5
1000 Mar-04 0
.............................
.............................

1001 Jan-04 2