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 |
|
johnstern
Yak Posting Veteran
67 Posts |
 Posted - 2007-12-14 : 16:02:46
|
| hello, what is the difference between left outer join an left join ? |
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-12-14 : 16:06:07
|
| Left outer join pulls all records back from the left table and only those that match in the right table. Left join pulls only records that match in both tables. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-14 : 16:11:10
|
quote:
Originally posted by Van
Left outer join pulls all records back from the left table and only those that match in the right table. Left join pulls only records that match in both tables.
No. LEFT OUTER JOIN is equivalent to LEFT JOIN. LEFT JOIN is just the short form, just like you can say JOIN instead of INNER JOIN.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Van
Constraint Violating Yak Guru
462 Posts |
Posted - 2007-12-17 : 10:31:15
|
| Oh yea...my bad. Looooong day last Friday. |
|
|
|
|
|
|
differences between left outer join an left join ?