Interested to Buy Any Domain ? << Click Here >> for more details...
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 are synonyms?
What are the different SQL Server Versions you have worked on?
Why we should not use triggers?
What are user defined functions in ms sql server?
What are the Advantages of using CTE in sql server?
What is the full meaning of dml?
What are different types of statements that are supported by sql?
What does select 1 mean?
What is set nocount on and what is set nocount off?
How to turn off warning messages during php execution?
What is meant by dirty read?
When would you use an insert into .. Select option versus an insert into .. Values option? Give an example of each?
How to create new databases with "create database" statements?
What are the difference between data mart and data warehouse? : sql server analysis services, ssas
What does truncate do?
