摘要:
-- 查询月服务天数不等于 数据库中存的月服务天数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 ... 阅读全文
posted @ 2015-09-08 20:08
w z y
阅读(223)评论(0)推荐(0)
编辑
摘要:
SELECT * from rpt_history_money where customer_price_per_day =0 and real_pay_money date(beable_service_days);SELECT count(DISTINCT service_day),order... 阅读全文
posted @ 2015-09-02 17:55
w z y
阅读(225)评论(0)推荐(0)
编辑
摘要:
1.SELECT * from aa WHERE aa not in(2,3) and aa not in(SELECT aa from aa where bb =1 and cc is null);2.(SELECT * from aa where bb not in (1,2,3)) UNION... 阅读全文
posted @ 2015-03-30 12:12
w z y
阅读(118)评论(0)推荐(0)
编辑