Thanks For the quick responses .....

DELETE FROM ABC

FROM ABC a

WHERE EXISTS ( SELECT ID FROM XYX x WHERE x._ID = a.ID)

AND Order_ID BETWEEN @MinID AND @MAXID

Using INNERJOIN:

DELETE FROM ABC

From ABC a

INNER JOIN Staging..XYZ x

ON a.Id = x.id

WHERE x.ID BETWEEN @MinID AND @MAXID

This is what i went with ...and he said Perfect ....

Thanks Again