Jose(提问者) 数据连接没问题

回复

2021-05-20 14:14 

取消 回复

Kevin-s 回复 Jose(提问者) SQL里面有用到其他用户的数据表么

回复

2021-05-20 14:16 

取消 回复

Jose(提问者) 回复 Kevin-s 没有 我用的是管理员的用户 这里的用户说的应该是FineBI的用户么？

回复

2021-05-20 14:23 

取消 回复

Kevin-s 回复 Jose(提问者) 是指数据库的用户，SQL长什么样可以看一下么

回复

2021-05-20 14:30 

取消 回复

Jose(提问者) 回复 Kevin-s SELECT DISTINCT TW.WAYBILL_NUMBER AS 延误单号, TO_DATE(TO_CHAR(TW.PICKING_DATE,\'YYYYMMDD\'),\'YYYYMMDD\') AS 拣配日期, TW.CUSTOMER AS 客户, TW.CARRIER_COMPANY AS 承运商, TOR.ORDER_TYPE AS 订单类型, TO_CHAR(TW.ESTIMATED_DATE_OF_ARRIVAL,\'YYYY-MM-DD\') AS 合同到货日期, TO_CHAR(TW.ARRIVAL_TIME,\'YYYY-MM-DD\') AS 实际到货日期, TO_DATE(TO_CHAR(TW.ARRIVAL_TIME,\'YYYYMMDD\'),\'YYYYMMDD\') - TO_DATE(TO_CHAR(TW.ESTIMATED_DATE_OF_ARRIVAL,\'YYYYMMDD\'),\'YYYYMMDD\') AS 延误, TWA.WAREHOUSE_NAME AS 发货仓库, TO_CHAR(TW.ESTIMATED_DATE_OF_ARRIVAL,\'YYYY-MM-DD\') AS 预计到货日期 FROM TMS_WAYBILL TW LEFT JOIN TMS_ORDER TOR ON TW.ORDER_NUMBER = TOR.ORDER_NUMBER LEFT JOIN TMS_WAREHOUSE TWA ON TW.WAREHOUSE = TWA.WAREHOUSE WHERE TW.CARRIER_COMPANY NOT LIKE \'%飞帆物流@%\' AND TOR.ORDER_TYPE NOT LIKE \'%部门领样%\' AND TOR.ORDER_TYPE NOT LIKE \'%个人领样%\' AND TW.CARRIER_COMPANY NOT LIKE \'%顺丰%\' AND TW.CUSTOMER NOT IN (\'上海所有的客户\',\'华润医药商业集团有限公司\',\'国药控股新疆新特西部药业有限公司\',\'广州医药有限公司\',\'广州医药有限公司狮山仓库\',\'广州医药有限公司（DJ）\',\'浙江省医药工业有限公司\') AND TO_CHAR(TW.PICKING_DATE,\'YYYY\') <> \'1970\' AND TO_CHAR(TW.ARRIVAL_TIME,\'YYYY\') <> \'1970\' AND TO_CHAR(TW.ESTIMATED_DATE_OF_ARRIVAL,\'YYYY\') <> \'1970\' AND (TO_DATE(TO_CHAR(TW.ARRIVAL_TIME,\'YYYYMMDD\'),\'YYYYMMDD\') - TO_DATE(TO_CHAR(TW.ESTIMATED_DATE_OF_ARRIVAL,\'YYYYMMDD\'),\'YYYYMMDD\')) >= 1

回复

2021-05-20 14:33 

取消 回复

还有5条评论 点击查看

评论