Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is Left Outer Join?

Answer Posted / prasanna

The result set of a left outer join includes all the rows
from the left table specified in the LEFT OUTER clause, not
just the ones in which the joined columns match. When a row
in the left table has no matching rows in the right table,
the associated result set row contains null values for all
select list columns coming from the right table.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define msdb database?

1017


Can you explain powershell included in sql server 2008?

939


How display code or Text of Stored Procedure using Sql query in Sql Server ?

1145


Can we call future method from queueable?

1047


What triggers long term care?

1036


what is create database syntax? : Sql server database administration

1104


Explain what are the basic functions for master, msdb, model, tempdb databases?

979


What happens if null values are involved in string operations?

992


What is tcl in sql server?

1122


Is natural join and equi join same?

971


How can i Relate Tables in SSIS

1081


What happens when the SQL Azure database reaches Max Size?

111


What are types of subqueries?

1067


How do I create a stored procedure in dbml?

1009


What is store procedure? How do they work? When do you use?

942