使用日历表填写日期范围查询中缺少的空白

I'm using the below query to pull back the total product price for a date range, however on the days that no sales where made, i'd like to still show the date but with a value of 0.I'm using the below query to pull back the tota