SQL 获取数据

SELECT COMPLAIN_CODE ‘投诉单号‘, ORDER_NO ‘订单号‘, RESPONSIBILITY ‘责任单位名称‘, CREATE_TIME ‘创建时间‘, COMPLAIN_TYPE ‘发起工单类型‘, DUTY_COMPLAIN_TYPE ‘定责投诉类型‘, COMPLAIN_SOUND_TYPE ‘声音归类‘, COMPLAIN_DATE ‘投诉日期‘, MEMO ‘情况说明‘, HANDLER1 “发起人工号“, HANDLER2 “结束人工号“, HANDLER_DATE1 “投诉开始时间“, HANDLER_DATE2 “投诉结束时间“, HANDLER_TYPE ‘处理类型‘, EOOR_SHIPPER_CONTACT ‘收货方联系人‘, EOOR_SHIPPER_CITY_NAME ‘发货地址城市‘, EOOR_CONSIGNEE_CITY_NAME ‘收货地址城市‘, EOOR_ORDER_TYPE ‘订单类型‘, SEND_DATE ‘发货时间‘, EOOR_SERVICE_MODE ‘服务类型‘, EOOS_SUPPLIER_FULL_NAME1’供应商全名‘, EOTS_LINK_TYPE ‘落地配‘FROM ( SELECT t.COMPLAIN_CODE, t.ORDER_NO, t.RESPONSIBILITY, t.CREATE_TIME, CASE t.COMPLAIN_TYPE WHEN ‘SAFETY’ THEN ‘安全类‘ WHEN ‘CUSTOMER’ THEN ‘客户类‘ WHEN ‘AGEING’ THEN ‘时效类‘ WHEN ‘ACTION’ THEN ‘客户体验类‘ WHEN ‘DELIVERY’ THEN ‘配送类‘ ELSE ‘货代业务线上化‘ END ‘COMPLAIN_TYPE’, t.COMPLAIN_SOUND_TYPE, t.COMPLAIN_DATE, t.MEMO, t.DUTY_COMPLAIN_TYPE, b. HANDLER ‘HANDLER1’, b.HANDLER_TYPE, c.EOOR_SHIPPER_CONTACT, c.EOOR_SHIPPER_CITY_NAME, c.EOOR_CONSIGNEE_CITY_NAME, c.EOOR_ORDER_TYPE, c.SEND_DATE, c.EOOR_SERVICE_MODE, d.EOOS_SUPPLIER_FULL_NAME ‘EOOS_SUPPLIER_FULL_NAME1′, CASE e.EOTS_LINK_TYPE when ’21’ THEN ‘收货‘ when ’22’ THEN ‘配单‘ when ’23’ THEN ‘发货‘ when ’24’ THEN ‘装机‘ when ’51’ THEN ‘提货主单‘ when ’61’ THEN ‘提货订单‘ when ’62’ THEN ‘货代签收‘ when ’71’ THEN ‘落地配交接‘ when ’72’ THEN ‘落地配分配‘ELSE ‘落地配签收‘ END ‘EOTS_LINK_TYPE’, min(b.HANDLER_DATE) ‘HANDLER_DATE1’ FROM cs_complained_info t LEFT JOIN cs_complained_handle_record b ON b. CODE = t.COMPLAIN_CODE LEFT JOIN eo_order c ON c.EOOR_ORDER_NO = t.ORDER_NO LEFT JOIN eo_order_supplier d ON d.EOOS_ORDER_NO = t.ORDER_NO LEFT JOIN eo_order_task_status e ON e.EOOR_ORDER_NO = t.ORDER_NO WHERE t.HANDLE_STATUS = “DONE” AND T.ORDER_NO != ” “AND t.CREATE_TIME > “2017-1-1” GROUP BY t.COMPLAIN_CODE ) AS ALEFT JOIN ( SELECT t.COMPLAIN_CODE ‘COMPLAIN_CODE2’, b. HANDLER ‘HANDLER2’, max(b.HANDLER_DATE) ‘HANDLER_DATE2’FROM cs_complained_info tLEFT JOIN cs_complained_handle_record b ON b. CODE = t.COMPLAIN_CODELEFT JOIN eo_order c ON c.EOOR_ORDER_NO = t.ORDER_NOLEFT JOIN开发云主机域名 eo_order_supplier d ON d.EOOS_ORDER_NO = t.ORDER_NOLEFT JOIN eo_order_task_status e ON e.EOOR_ORDER_NO = t.ORDER_NOWHERE t.HANDLE_STATUS = “DONE”AND b.HANDLER_RESULT = “FINISH”AND T.ORDER_NO != ” “AND t.CREATE_TIME > “2017-1-1”GROUP BY t.COMPLAIN_CODE) AS B ON A.COMPLAIN_CODE = B.COMPLAIN_CODE2ORDER BY COMPLAIN_CODE DESC

相关推荐: 怎么写mysql外键约束

今天就跟大家聊聊有关怎么写mysql外键约束,可能很多人都不太了解,为了让大家更加了解,小编给大家总结了以下内容,希望大家根据这篇文章可以有所收获。mysql外键约束的写法:【[CONSTRAINT ] FOREIGN KEY 字段名 REFERENCES 主…

免责声明:本站发布的图片视频文字,以转载和分享为主,文章观点不代表本站立场,本站不承担相关法律责任;如果涉及侵权请联系邮箱:360163164@qq.com举报,并提供相关证据,经查实将立刻删除涉嫌侵权内容。

(0)
打赏 微信扫一扫 微信扫一扫
上一篇 06/09 15:16
下一篇 06/09 15:16

相关推荐

发表评论

您的电子邮箱地址不会被公开。