In order to display records for dates which are not found in the table you are reporting on, you should build you query based on your calendar table aux.date which then you should LEFT JOIN to the rest of tables.

You have providede too little information in order to write exact query you can use. If you need more help, please read the article from the link found at the bottom of my signature. It explains what is required in order to attract most relevant and prompt help.