In case of sub query sql server affects in speed so as less as possible use this best use is join

Ranjan

Developer in http://www.Hamarashehar.com