Shulou(Shulou.com)06/01 Report--

UPDATE Bins b SET b.ShopSn = '111201611111168706' WHERE b.Id IN (SELECT b.Id FROM Bins b JOIN BinInventory bi ON bi.BinId = b.Id WHERE bi.Quantity > 0 AND b.IsEnable=1 AND bi.IsEnable = 1)

UPDATE Bins b SET b.ShopSn = '111201611111168706' WHERE b.Id IN (select * from (SELECT b.Id FROM Bins b JOIN BinInventory bi ON bi.BinId = b.Id WHERE bi.Quantity > 0 AND b.IsEnable=1 AND bi.IsEnable = 1) as Y)

The same situation also exists in testing delete.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.