Help creating a query!

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.

Here you are..

Quote:

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

Quote:

Originally Posted by yossf666666 Here you are..

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

[Only registered and activated users can see links. Click Here To Register...]


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


thanks in advance.

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

Quote:

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.

Quote:

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.