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 trace files?
Explain where clause?
optimization techinques
What is 2nf example?
Explain about analysis services?
How to drop an existing table?
Explain hostprotectionattribute in sql server 2005?
What is the difference between push and pull subscription? : sql server replication
How to bind a view to the schema of the underlying tables?
What are the differences between decimal and float in ms sql server?
What is GUID in sql server?
what is the difference between Tabular and Matrix report?
What is ddl command?
What is store procedure? How do they work? When do you use?
How to create a trigger for insert only?
