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 |
|
hariniiyer
Starting Member
1 Post |
 Posted - 2012-04-16 : 14:09:19
|
Hello All,I have tough time understanding joins. Been scratching my head for quite a some time now on how this works. Would be happy if some explains this. Please give me a good example other than employee,mgr  .Thanks,Meenakshi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
vinu.vijayan
Posting Yak Master
227 Posts |
Posted - 2012-04-17 : 02:41:27
|
| Inner JOIN[url]http://msdn.microsoft.com/en-us/library/aa213234(v=sql.80).aspx[/url]Outer JOIN[url]http://msdn.microsoft.com/en-us/library/ms187518.aspx[/url]Self JOINhttp://msdn.microsoft.com/en-us/library/ms177490.aspxN 28° 33' 11.93148"E 77° 14' 33.66384" |
 |
|
|
|
|
|
Understanding Self Joins