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 |
|
joxa831
Starting Member
7 Posts |
 Posted - 2008-09-17 : 09:41:24
|
| So far I have read (and tried) that there is not difference between LEFT - LEFT OUTER and RIGHT - RIGHT OUTER joins, but if there is no difference at all why do we have both options? Are there any performance issues or some compatibility issues? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-17 : 09:44:11
|
| OUTER is just an optional word. they mean one and the same. |
 |
|
|
|
|
|
LEFT - LEFT OUTER and RIGHT - RIGHT OUTER