Interested to Buy Any Domain ? << Click Here >> for more details...
Please explain the difference between outer join and inner
join? With examples would be appreciable..!
- 6 Answers
- 19134 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / khalek
In Inner Join Only Matching Records come while in Outer Join
All Matching Records + All Non Matching Record(Based on
Outer Join type).
Outer join may be any type from following.
1) Left Outer Join
2) Right Outer Join
3) Full Outer Join
You can see full detail at
<a
href="http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html">http://interview-preparation-for-you.blogspot.com/2010/11/difference-between-inner-joinouter-join.html</a>
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
Explain the use of file option in exp command.
Why does for update in oracle 8 cause an ora-01002 error?
Explain the use of tables option in exp command.
What is an index associated with a constraint?
Explain the use of control file?
what is the difference between data migration and production migration.
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to define a variable to match a table column data type?
What are named parameters?
How to save query output to a local file?
what is the use of system.effective.date variable in oracle?
What is null value in oracle?
How to view the data files in the current database?
What is the difference between a primary key & a unique key?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
