Answer Posted / samba shiva reddy . m
Full Outer join it will take all the records from the both the tables.
Example:
Table1 : emp
______________
empid empname
______________
1 samba
______________
2 Anju
______________
NULL Shiva
______________
5 NULL
______________
Table2 : user
______________
uid uname
______________
1 raju
______________
2 Khan
______________
3 Sripal
______________
4 Sathosh
______________
NULL Srinu
______________
9 NULL
______________
We will write the Full Outer join on both the table
Select * from emp full outer join [user] on emp.empid=[user].uid
the result will be both the tables with NULL vslues
but in the cross join it is bsed on the rows
in the cross join it will give the combination of all rows
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the use of keyword with encryption. Create a store procedure with encryption?
How to use values from other tables in update statements in ms sql server?
Tell me what is difference between view and materialized view?
How to connect to a sql server using odbc_connect()?
Do you know exporting and importing utility?
Does view occupy space?
What are sql server functions?
What is use of dbcc commands?
What is read uncmmited?
Explain Geometry datatype in sql server 2008 with example
What is attribute? : sql server analysis services, ssas
What do mean by xml datatype?
What are different types of raid configurations? : SQL Server Architecture
List down some advantages of sql stored procedure?
What is a bit datatype?
