Quote:
use JSRO_SHARDTEST
select b.service,a.maxstack,a.ID,b.codename128 from _RefObjItem a inner join _RefObjCommon b on a.ID=b.Link
and b.codename128 like '%cure%'
order by MaxStack
Update your item maxstack
Quote:
use JSRO_SHARDTEST
update _RefObjItem set MaxStack = 100 where id in (select link from _RefObjCommon where CodeName128 like '%cure%')






