You're right.   I just wasn't seeing it.

In this dataset if I want the subquery and outerquery to return results I need to join on YYYYMM  instead of Datekey which is YYYYMMDD. 

Thanks for looking at this, Jacob.