Quote:
Originally Posted by revldo1
i want delete is teleport
|
made you query to make it fast.
Code:
USE [YOUR DB NAME]
go
select dwTacticsID from Tab_RefTactics where dwObjID in (select id from _RefObjCommon where CodeName128 like 'YOUR TELEPORT CODENAME U WANT TO DELETE')
After you get the DwTacticsID, simple use it on the 2nd query.
Code:
delete from tab_RefNest where Tab_RefTactics like 'THE dwTacticsID You got from 1st query here'