22,210
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO jd_order_detail(订单编号,商品条码,下单数量,发车数量) values (1996,6953721700077,555,555)
SELECT dbo.jd_order_detail.订单编号, dbo.jd_order_detail.京东编码, dbo.jd_order_detail.商品条码, dbo.jd_order_detail.下单数量, dbo.jd_order_detail.发车数量, dbo.jd_order_detail.物流放置数量,
dbo.jd_order_detail.车号, dbo.jd_order_detail.物流单号, dbo.jd_order_detail.计划发车地, dbo.jd_order_detail.生产日期, dbo.jd_order_detail.备注, CASE WHEN truck.[到京/抵达时间] IS NOT NULL
THEN jd_order_detail.发车数量 - SUM(CASE WHEN order_problem.异常时间 = '交托前' THEN isnUll(order_problem.异常数量, 0) ELSE 0 END) ELSE NULL END AS 到京数量,
CASE WHEN jd_order_entry.入库日期 IS NOT NULL THEN jd_order_detail.发车数量 - SUM(ISNULL(dbo.order_problem.异常数量, 0)) ELSE NULL END AS 预计实收数量, dbo.jd_order_detail.实收数量,
dbo.truck.目的地, dbo.truck.发车时间, dbo.truck.发车地点, dbo.truck.发车车次, dbo.truck.货车型号, dbo.truck.[到京/抵达时间], dbo.truck.是否直发, dbo.truck.运费, dbo.jd_order_entry.平台,
dbo.jd_order_entry.地区, dbo.jd_order_entry.订单状态, dbo.jd_order_entry.库房名称, dbo.jd_order_entry.入库日期, dbo.jd_order_entry.下单日期, dbo.jd_order_entry.预约日期,
dbo.jd_order_entry.自定义名称
FROM dbo.jd_order_detail LEFT OUTER JOIN
dbo.order_problem ON dbo.jd_order_detail.订单编号 = dbo.order_problem.订单编号 AND dbo.jd_order_detail.商品条码 = dbo.order_problem.商品条码 LEFT OUTER JOIN
dbo.jd_order_entry ON dbo.jd_order_detail.订单编号 = dbo.jd_order_entry.订单编号 LEFT OUTER JOIN
dbo.truck ON dbo.jd_order_detail.车号 = dbo.truck.车号
GROUP BY dbo.jd_order_detail.订单编号, dbo.jd_order_detail.京东编码, dbo.jd_order_detail.商品条码, dbo.jd_order_detail.下单数量, dbo.jd_order_detail.发车数量, dbo.jd_order_detail.实收数量,
dbo.jd_order_detail.物流放置数量, dbo.jd_order_detail.车号, dbo.truck.[到京/抵达时间], dbo.jd_order_entry.入库日期, dbo.jd_order_detail.物流单号, dbo.jd_order_detail.计划发车地,
dbo.jd_order_detail.生产日期, dbo.jd_order_detail.备注, dbo.truck.目的地, dbo.truck.发车时间, dbo.truck.发车地点, dbo.truck.发车车次, dbo.truck.货车型号, dbo.truck.[到京/抵达时间],
dbo.truck.是否直发, dbo.truck.运费, dbo.jd_order_entry.平台, dbo.jd_order_entry.地区, dbo.jd_order_entry.计划发车地, dbo.jd_order_entry.订单状态, dbo.jd_order_entry.库房名称,
dbo.jd_order_entry.入库日期, dbo.jd_order_entry.下单日期, dbo.jd_order_entry.预约日期, dbo.jd_order_entry.自定义名称