Query to modify Tab_RefTactics

[zikor1337]

Ok, so, I've been trying to create a query that is going to modify the dwObjID from Tab_RefTactics with the ID from _RefObjCommon just by giving it the range, something like : update mob MOB_KT_BUNWANG with MOB_JUPITER_JUPITER .


I've been trying doing it with "left join" and some other stuff. They didn't worked. Any ideas ?

[MentaL]

[collerok]

http://forum.ragezone.com/f722/sql-q...e-spot-855558/
you can gain some information from this script

[RevoLand]

UPDATE Tab_RefTactics SET Range = 123 WHERE dwObjID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = 'MOB_KT_BUNWANG')

for multiple values;

UPDATE Tab_RefTactics SET Range = 123 WHERE dwObjID in (SELECT ID  FROM _RefObjCommon WHERE CodeName128 LIKE '%MOB_KT_%')

it must work.