研究了一下 呵呵 还是比较简单的
update ITEM_UPGRADE set ngenrate= ngenrate * 0.9 //降低
update ITEM_UPGRADE set ngenrate= ngenrate / 0.9 //升高
select nindex,nReqItem1,szname,ngenrate from ITEM_UPGRADE IU,UPGRADEEXT0_CH UC WHERE uc.dwID=iu.nReqItem1 order by nIndex //查看
select nindex,nReqItem1,szname,ngenrate from ITEM_UPGRADE IU,UPGRADEEXT0_CH UC WHERE uc.dwID=iu.nReqItem2 order by nIndex //查看 |