Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sital
Yak Posting Veteran
89 Posts |
 Posted - 2008-12-10 : 01:29:03
|
| Hi Can anyone help me out in resolving my following question?There are 4 Types of Joins - Inner Join, Outer Join and Self Join,Equi join.How can I identify which join should be used for generating a query? |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-12-10 : 01:45:09
|
| according to your requirement...mostly left outer joins are useful in realtime scenarioArnavEven you learn 1%, Learn it with 100% confidence. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-10 : 02:14:17
|
| inner join looks for exact matchesouter joins looks for details regardless of matches and brings supplement info based on matching conditionself join is nothing but joining same table to itself the selection of which join to be used depends on your actual requirement scenario |
|
|
|
sital
Yak Posting Veteran
89 Posts |
Posted - 2008-12-10 : 07:48:46
|
quote:
Originally posted by sital
Hi Can anyone help me out in resolving my following question?There are 4 Types of Joins - Inner Join, Outer Join and Self Join,Equi join.How can I identify which join should be used for generating a query?
Thanks alot for helping me out in querying. |
|
|
|
|
|
|
Joins