c.code = e.code
and not also including year
is that e.g. the 2010 value for fertility_rate
is also paired with the 2015 value for unemployment_rate
.ON
clause, use AND
to add an additional joining condition. In addition to joining on code
in c
and e
, also join on year
in e
and p
.