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
Can you tell me about the concept of ER diagrams?
What are different types of statement?
What is inner join? Explain with an example?
What is the difference between varchar and nvarchar datatypes?
How to set a database state to offline in ms sql server?
How exceptions can be handled in sql server programming?
How to enable tcp/ip protocol on a sql server?
What is reportserver and reportservertempdb ?
How to create an index on a view?
How to manipulate data from one table to another table ?
What are triggers in ms sql server?
What is the command used to recompile the stored procedure at run time?
Explain magic tables in sql server?
What is bit data type? What's the information that can be stored inside a bit column?
What according to you is the difference between mysql and sql server performance?
