摘要: SELECT A.datelist AS pick_dt, IFNULL(B.pick_cnt, 0) pick_cnt, IFNULL(B.cust_cd, 0) cust_cd //IFNULL(A,B) --如果结果不等于null,则返回A,等于null,就返回BFROM calendar A 阅读全文
posted @ 2018-11-09 09:51 up-zyn 阅读(182) 评论(0) 推荐(0) 编辑