I have table with following fields
id
client_id
monthly_date
page_counts
I am trying to get list of clients with date missing for page_counts
SELECT *
FROM (SELECT monthly_date as months from stats_entry group by monthly_date ) AS m
LEFT JOIN stats_entry ep
ON m.months = ep.monthly_date
group by client_id, monthly_date
But it still shows clients with available dates only with left join? What i am missing?