Sivaraman,

> i can use the Exists also.But my dba is telling that don't use
> subqueries.

Your DBA is wrong!!!

Ask him to write out the statement if he's so sure he knows better -- he
doesn't!


Sean