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
Define msdb database?
Can you explain powershell included in sql server 2008?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
Can we call future method from queueable?
What triggers long term care?
what is create database syntax? : Sql server database administration
Explain what are the basic functions for master, msdb, model, tempdb databases?
What happens if null values are involved in string operations?
What is tcl in sql server?
Is natural join and equi join same?
How can i Relate Tables in SSIS
What happens when the SQL Azure database reaches Max Size?
What are types of subqueries?
How do I create a stored procedure in dbml?
What is store procedure? How do they work? When do you use?