
轻设计 / 轻生活 / 轻日记 / 轻梦想
=== 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)