let table R(A,B) is
A B
a 1
b 2
c 3
let table S(C,B) is
C B
x 1
y 4
z 3
you are doing Natural join, B is common attribute. ( order of tuples and attributes are not sure, but i hope my analysis is right! )
the resultant table of R NATURAL JOIN S is
A B C
a 1 x
c 3 z
the resultant table of R NATURAL LEFT OUTER JOIN S is
A B C
a 1 x
b 2 (NULL)
c 3 z
the resultant table of R NATURAL RIGHT OUTER JOIN S is
A B C
a 1 x
c 3 z
(NULL) 4 y
the resultant table of R NATURAL FULL OUTER JOIN S is
A B C
a 1 x
b 2 (NULL)
c 3 z
(NULL) 4 y
the resultant table of S NATURAL JOIN R is
C B A
x 1 a
z 3 c
the resultant table of S NATURAL LEFT OUTER JOIN R is
C B A
x 1 a
y 4 (NULL)
z 3 c
the resultant table of S NATURAL RIGHT OUTER JOIN R is
C B A
x 1 a
z 3 c
(NULL) 2 b
the resultant table of S NATURAL FULL OUTER JOIN R is
C B A
x 1 a
y 4 (NULL)
z 3 c
(NULL) 2 b
