Page 1 of 1

Difference between Join and Subquery

PostPosted: Fri Feb 03, 2012 12:48 pm
by coollearner
1)How can we decide whether to choose a join or subquery is needed? I mean for what kind of queries a join is recommended and when a subquery is recommended.
2)How can we identify whether a subquery or correlated subquery is needed? I need a thumb rule.