The answer to the OP question is to use LEFT JOIN

SELECT Calendar.date, shiftQuery.* From Calendar LEFT JOIN shiftQuery on Calendar.date = shiftQuery.date

This will give you the calendar record EVERY TIME and the shift record IF IT EXISTS