Inner Join in Oracle

In Oracle database  R1 inner join R2

Those tuple of R1 will get combined with tuple of R2 if they have same value for the common attribute.

common attribute or column that have the same name in both table

Note-if in two table attribute same show common element from both table will be fetch.

Example 1

Output

A       B       C       D

X       10     100      L

Y       20     100     L

Z       30     200      M

Example 2

Output

A       B       C       D

X       10     100      L

Y       20     100     L

Z       30      200     M

X       10     100      T

Y       20     100     T