purushottam2 (9/16/2012)

---

I want to know which query is more optimized?

SELECT 1 FROM ABC WHERE Id IN (SELECT Id FROM ABC1)

===================================================

SELECT 1 FROM ABC a JOIN ABC1 b ON a.Id = b.Id

Thanks

Puru