self doubts[ join]

Question

Having confusion in solving NATURAL LEFT OUTER JOIN AND NATURAL FULL OUTER JOIN can anyone explain with example

Comments

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

---

Thanks