Hi All

can anybody specify the situation where subquery is must to use and
joins cant solve the purpose ? plz also give query example if possible
Basically I want to know when are we forced to use subqueries insteasd of join


thx
perl