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 |
|
pazzy11
Posting Yak Master
145 Posts |
 Posted - 2007-10-08 : 07:05:41
|
| ok i need to know the difference between inner outer , left , right joins ....anyone know any good tutorials ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
pazzy11
Posting Yak Master
145 Posts |
Posted - 2007-10-08 : 11:48:55
|
| So LEFT JOIN is the same as LEFT OUTER JOIN then ?? there is no such thing as LEFT INNER JOIN since INNER returns data from both joined tables ?same for RIGHT JOIN ? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-08 : 11:51:20
|
You are right in both cases.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
anyone direct me to good JOIN tutorials..