SELECT receiving.ref_id AS 'PO单', receiving.receiving_code AS 'ASN号', receiving.contact AS '采购员',
(CASE receiving.category
WHEN 51 THEN '手机电子'
WHEN 52 THEN '汽摩配'
WHEN 53 THEN '家居装饰'
WHEN 54 THEN '运动'
WHEN 55 THEN '服装'
WHEN 56 THEN '珠宝'
WHEN 57 THEN '玩具'
WHEN 58 THEN '婚庆'
WHEN 59 THEN '手工'
WHEN 60 THEN '园艺'
WHEN 61 THEN '爱好'
WHEN 62 THEN '美妆'
WHEN 63 THEN '电脑电子'
WHEN 64 THEN '宠物灯饰'
WHEN 65 THEN '骑行渔具'
WHEN 66 THEN '户外'
WHEN 67 THEN '摩配'
WHEN 68 THEN '消费电子'
WHEN 69 THEN '娃娃配件'
WHEN 70 THEN '厨卫家电'
WHEN 71 THEN '服装配件'
WHEN 72 THEN '家居用品'
WHEN 73 THEN '工业'
WHEN 74 THEN '缝纫'
WHEN 75 THEN '个护'
WHEN 76 THEN '收藏'
WHEN 77 THEN '游戏摄影'
WHEN 78 THEN '乐器'
WHEN 79 THEN '商业'
WHEN 80 THEN '婴幼'
END) AS '品类', receiving_pre.rp_receiving_time AS '收货时间',
(CASE receiving_pre.rp_qclevel
WHEN 1 THEN '紧急'
ELSE '常规'
END) AS '收货时ASN优先级', receiving_pre_map.rpm_unpack_time AS '开箱时间',
(CASE receiving.asn_level
WHEN 1 THEN '紧急'
ELSE '常规'
END) AS '开箱时ASN优先级' FROM receiving_pre JOIN receiving_pre_map ON receiving_pre.rp_tracking_number=receiving_pre_map.rp_tracking_number JOIN receiving ON receiving_pre_map.receiving_code=receiving.receiving_code WHERE receiving_pre.rp_receiving_time>='2019-09-14 00:00:00' AND receiving_pre.rp_receiving_time<='2019-10-15 00:00:00';
结果: