Fill-in Missing Dates with calendar table Hi i want the output to look like this. Filling the missing dates from the DATE_TBL. I tried UNION but no luck. 



From this table: Log_table:



and DATE_TBL
FROM DATE_TBL
LEFT JOIN LOG_TBL USING(date)