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 |
|
cards44
Starting Member
2 Posts |
 Posted - 2007-01-15 : 14:24:45
|
| I'm relatively new to SQL and I am wondering about when to use left outer joins. When should you use left outer joins? |
|
|
Vijaykumar_Patil
Posting Yak Master
121 Posts |
Posted - 2007-01-15 : 14:29:07
|
| Left Outer Join is used when you need all the Rows from the first table (Left table) and data only for the matching rows in the Second Table (Right Table).You can also have Right Outer Joins.Necessity is the mother of all inventions! |
 |
|
|
cards44
Starting Member
2 Posts |
Posted - 2007-01-15 : 14:33:07
|
| Thank you. |
|
|
|
|
|
|
Left outer join