What different of iner joint & outer joint with example
Answer Posted / tripti gour
INNER JOIN: inner join fetch only matched data from 2 or
more tables.
ex: select empno, ename, e1.deptno, d1.deptno, dname
from emp e1, dept d1
where e1.deptno = d1.deptno;
output will the all records whose deptno is exists in both
table (emp and dept)
OUTER JOIN: is used to fetched matched and unmatched data
from 2 or more tables.there are 3 type of outer join:
Right outer join , Left outer join, Full outer join.
Right outer join will display the matched and unmatched
records of right side located table.and Left outer join does
just opposite of it.and Full outer join will display matched
and unmatched both type of records from both tables.
ex: select empno, ename, e1.deptno, d1.deptno, dname
from emp e1 right outer join dept d1
on e1.deptno =d1.deptno;
Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Difference between open_form and call_form in oracle.
What is oracle open database communication (odbc)?
How many types of auditing in Oracle?
What is a table in oracle?
What are triggers in oracle?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
What happens if the update subquery returns multiple rows?
What is a package in oracle?
material view and view disadvantages?
How can I introduce multiple conditions in like operator?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is the difference between truncate & delete command?
How can I combine multiple rows into a comma-delimited list in oracle?
various types of hints and their usage
What do you understand by a database object? Can you list a few of them?