Help creating a query!

[devdash]

i need a query to use IDs like "MOB_CH_STONEGHOST"

and get all the RefNest lines that linked with it, so i can go there and edit the lines as i want


i got the idea, but idk how to create a query

so the query will use mob ID "MOB_CH_STONEGHOST" to search in RefObjCommon & get the ID Number then with the number it will go to RefTactics then with RefTactics it will get the RefNest lines


i hope that help in creating...


i will really appreciate if someone make it, since everyone of us have to edit RefNest somehow, so why not have a good query instead of manual searching..

NOTE: "MOB_CH_STONEGHOST" is an example
thanks in advance.

[VeRo!]

Here you are..

USE [SRO_VT_SHARD]
SELECT [dwNestID] FROM [dbo].[Tab_RefNest] WHERE dwTacticsID in
( SELECT [dwTacticsID] FROM [dbo].[Tab_RefTactics] WHERE dwObjID like
(select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC') )

[devdash]

Originally Posted by yossf666666

Here you are..

thank you so much, that's what i wanted but




can we make it showup the full line ? not only the IDs..


thanks in advance.

[sarkoplata]

instead of "Select dwNestID from...", just type "select * from..."
or if you want specific columns, type them one by one, seperated by a comma.

[devdash]

Originally Posted by sarkoplata

instead of "Select dwNestID from...", just type "select * from from..."
or if you want specific columns, type them one by one, seperated by a comma.

gonna try it now, and write back.

Originally Posted by sarkoplata

instead of "Select dwNestID from...", just type "select * from..."
or if you want specific columns, type them one by one, seperated by a comma.

fixed with * welldone bruh

thanks,

#RequestCloseTopic please.