Difference between Join and Subquery



IBM's flagship relational database management system

Difference between Join and Subquery

Postby coollearner » Fri Feb 03, 2012 12:48 pm

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.
Knowledge is wealth
coollearner
 
Posts: 33
Joined: Thu Jun 03, 2010 3:15 pm
Has thanked: 0 time
Been thanked: 0 time

Return to DB2

 


  • Related topics
    Replies
    Views
    Last post