Hi All,

Can any body state the situations where we cant use joins but have to use subquery ? Also when in the situation where we can use the both , when should we use subquery ?

will be more helpful if someone states with example


many thnx
perl