MS SQL Resultset zero Totals for Values That Don't Exist : [SQL Fiddle][1]


I'm trying to force through zero values for grades that don't exist in my "results" table, but do exist in my list of possible "grades" table.

I've managed to join tables successfully in order to almost achieve this using [this previous post][2] as guidance up to a point.

As you can see from my fiddle the resultset is displaying NULL values for my Year and Subject columns and I would like these to display the relevant subject.


  [1]: http://sqlfiddle.com/#!9/85aa1/15 "SQL Fiddle"
  [2]: http://stackoverflow.com/questions/27162465/how-can-i-create-a-row-for-values-that-dont-exist-and-fill-the-count-with-0-val "Previous Post"