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
How to get a list of columns using the "sys.columns" view in ms sql server?
If I delete a template from the list in sql studio, will it be deleted from the hard disk? : sql server management studio
What is difference between materialized view and view?
How to retrieve field values using mssql_result()?
What are the recovery models for a database?
How many types of stored procedures are there in sql server?
How to use “drop” keyword in sql server and give an example?
In which format does an image save in SQL Server database ?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?
what is nonclustered index
How to retrieve error messages using mssql_get_last_message()?
How do I connect to sql server database?
What is the maximum size of sql server database?
explain how to create a new schema in a database? : Sql server database administration
What are indexers?