
我的名字:“周末”
程序猿/轻设计/轻生活/轻日记/轻梦想
=== 微信:zhoumojianshe ===
搜索
DELETE FROM #TempCountLP FROM #TempCountLP S WHERE NOT EXISTS (SELECT 1 FROM "8002".tbCountTable zb, "8002".tbCountTableDetail cb WHERE zb.BillNumber = cb.BillNumber AND zb.CountID = 114 AND CounterCode = S.CounterCode AND LocationCode = S.LocationCode AND GoodsCode = S.GoodsCode)