What is Full Outer Join?

Question Posted / g.ramesh

3 Answers
4952 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is Full Outer Join?..

Answer / g.ramesh

It produce Result Set which contains matched rows and both
side tables unmatched rows.

Is This Answer Correct ?

2 Yes

0 No

What is Full Outer Join?..

Answer / pushpa

Join interms of database combining two or more tables.
we have many joins.
inner join,self join,outer join,cross join.
in outerjoin we have three types.
left outer join
right outer join
full outer join
if we want to join two tables--
use left outer join- get the matched columns of two tables & ramaining columns of left hand side table of the join statement.

use right outer join- get the matched columns of two tables & ramaining columns of right hand side table of the join statement.

use full outer join- get the matched columns of two tables & ramaining columns of left hand side table and right hand side table of the join statement.

Is This Answer Correct ?

1 Yes

0 No

What is Full Outer Join?..

Answer / naren

matching columns of left and right tables and unmatched columns of both tables is displayed.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer