-- 查询月服务天数不等于 数据库中存的月服务天数
SELECT b.day1,a.days_of_month from erp_work_day_opt_info_copy a, (select count(DISTINCT service_day) as day1 , order_id from erp_work_day_opt_info_copy where service_day >= '2015-08-01' and service_day <= '2015-08-01' and order_state =4 GROUP BY order_id )b where a.order_id = b.order_id and service_day = '2015-08-01' and order_state =4 and b.day1 != a.days_of_monthSELECT b.day1,a.da
