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.
Difference between Join and Subquery
Previous topic • Next topic • 1 post
• Page 1 of 1
Previous topic • Next topic • 1 post
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- Difference between inner join and self join
by sankar » Thu Mar 27, 2008 4:47 pm - 1 Replies
- 2862 Views
- Last post by arunprasad.k
Thu Mar 27, 2008 7:11 pm
- Difference between inner join and self join
-
- Subquery in INSERT statement
by unique » Fri May 13, 2011 7:04 pm - 1 Replies
- 4303 Views
- Last post by GuyC
Fri May 13, 2011 8:21 pm
- Subquery in INSERT statement
-
- (Table1 inner join Table2) left outer (table3 inner join t4)
by Raja190 » Sat May 21, 2016 1:22 pm - 1 Replies
- 1862 Views
- Last post by Raja190
Sat May 21, 2016 6:02 pm
- (Table1 inner join Table2) left outer (table3 inner join t4)
-
- Outer Join
by KRISHAN » Thu Oct 07, 2010 5:17 pm - 3 Replies
- 2154 Views
- Last post by RENGANATHAN
Sat Nov 20, 2010 8:09 am
- Outer Join
-
- Table Join
by Vineet » Mon Jun 20, 2011 6:17 pm - 1 Replies
- 2037 Views
- Last post by GuyC
Mon Jun 20, 2011 6:47 pm
- Table Join