SaveText.Ru

Без имени
  1. DELETE FROM TDOCUMCONTENT DC WHERE EXISTS (SELECT DT.FID FROM TDOCUMTITLES DT WHERE DC.FDOCID = DT.FID AND DT.FSTATE IN (0,1)) AND ( EXISTS (SELECT S.FID FROM TSTORE S WHERE DC.FSTOREID = S.FID AND S.FGOODSID = 847));
  2. UPDATE TSTORE SET FAMOUNT = 0, FRESERV = 0 WHERE FGOODSID = 847 AND FID <> 971;
  3. UPDATE TSTORE SET FAMOUNT = 2, FRESERV = 0 WHERE FID = 971;
  4. UPDATE TGOODS SET FAMOUNT = 2, FRESERV = 0 WHERE FID = 847;

Share with your friends:

Print