Mysql: Clients with missing monthly data

32 views Asked by At

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?

0

There are 0 answers