UPDATE goods g,shoppingcar sSETg.SOLD_NUM=g.SOLD_NUM+s.NUM,g.NUM=g.NUM-s.NUMwhere g.ROW_ID=s.GOODS AND g.ROW_ID IN ('1','2','3'); ]]>
