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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Left Outer Join

Author  Topic 

AbdulJavedKhan786
Starting Member

1 Post

Posted - 2009-03-03 : 23:54:45
Left outer join in details

Nageswar9
Aged Yak Warrior

600 Posts

Posted - 2009-03-03 : 23:56:48
See Books in online and can u explaing what u want
Go to Top of Page

Nageswar9
Aged Yak Warrior

600 Posts

Posted - 2009-03-03 : 23:58:34
The Left Outer Join operator returns each row that satisfies the join of the first (top) input with the second (bottom) input. It also returns any rows from the first input that had no matching rows in the second input. The nonmatching rows in the second input are returned as null values.
Go to Top of Page

bklr
Master Smack Fu Yak Hacker

1693 Posts

Posted - 2009-03-04 : 00:04:24
see this link for outer joins
http://www.sqlteam.com/article/writing-outer-joins-in-t-sql
Go to Top of Page
   

- Advertisement -