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
What is ems sql management studio? : sql server management studio
What is the name of reporting services config file and what’s it’s used for?
What are the transaction properties?
How optimize sql query with multiple joins in sql server?
What is after dml trigger?
What is fill factor and pad index?
What is user-defined inline table-valued function?
How do you Implement SSIS Packages in your Project?
What is rank function?
Explain user defined views?
What is a data source file?
How do I delete a sql server database?
How to check if a table is being used in sql server?
What are different types of database indexes?
What is the difference in accessing db between sql server vs sql azure?