Help Build a Query

[devdash]

i need to make a query to change nRegionDBID from _RefNest table by using the RefObjCommon ID "MOB_QT_TQ_THIEF_01" for example



so in the query i have to put the new nRegionDBID number and RefObjCommon mob ID


thanks in advance.

[VeRo!]

Here you go...

UPDATE Tab_RefNest
SET nRegionDBID = 'x'
WHERE dwNestID IN
(SELECT [dwNestID] FROM [dbo].[Tab_RefNest] WHERE dwTacticsID IN
( SELECT [dwTacticsID] FROM [dbo].[Tab_RefTactics] WHERE dwObjID IN
(select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC') ) )

[devdash]

Originally Posted by yossf666666

Here you go...

thanks alot