Help Build a Query

04/16/2019 12:20 devdash#1

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.

04/16/2019 14:28 VeRo!#2

Here you go...

Quote:

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') ) )

04/16/2019 15:06 devdash#3

Quote:

Originally Posted by yossf666666

Here you go...

thanks alot