What is Inner Joints and Outer Joints ? What is right outer joints,left outer j

What is Inner Joints and Outer Joints ?
What is right outer joints,left outer joints,right inner
joints , left inner joints ,

Question Posted / basawaraj b

2 Answers
8164 Views
HP, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner j..

Answer / sunil kumar

Inner join=>Inner join returns rows when there is at least
one match in both tables.

Outer Join=> Outer Join returns the set of all matching
records from both tables. Outer join doesn`t require each
record to be matched in both the tables.

Right Outer Join=>Return all the rows of second table ,plus
matching record of both tables.

Left Outer Join=>Return all the rows of first table,plus
matching record of both tables.

Is This Answer Correct ?

26 Yes

0 No

What is Inner Joints and Outer Joints ? What is right outer joints,left outer joints,right inner j..

Answer / muthuk

Outer Join=> Outer Join returns the set of all matching
records from both tables. Outer join doesn`t require each
record to be matched in both the tables.

Inner join=>Inner join returns rows when there is at least
one match in both tables.

Left Outer Join=>Return all the rows of first table,plus
matching record of both tables.

Right Outer Join=>Return all the rows of second table ,plus
matching record of both tables.

Is This Answer Correct ?

5 Yes

1 No

Post New Answer