adspace


Define left outer join in sql server joins?

Answer Posted / Sayed Mohd Nadeem

A Left Outer Join (also known as a Left Join) in SQL Server returns all rows from the left table (table on the left side of the join clause), with matched rows from the right table (table on the right side of the join clause). If there is no match, then NULL values are used for unmatched right table columns.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert character strings into numeric values?

1190


What is the difference between for xml raw and for xml auto?

1117


do you know how to configure db2 side of the application? : Sql server database administration

1124


Can one drop a column from a table?

1089


List the ways in which dynamic sql can be executed?

1086


How to enter binary string literals in ms sql server?

1244


What are the different types of subquery?

1235


Why should you use or avoid select * statements?

1109


Where can you add custom error messages to sql server?

1211


Why we use the openxml clause?

1079


How efficient you are in oracle and SQL server?

1257


List out the different types of locks available in sql server?

1050


what is the Ticketing tool used in Wipro technologies at Bangalore...???

8230


How raid can influence database performance?

1117


Can we shrink data file in sql server?

1128