0 votes 0 votes Having confusion in solving NATURAL LEFT OUTER JOIN AND NATURAL FULL OUTER JOIN can anyone explain with example altamash asked Oct 22, 2018 altamash 340 views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply Shaik Masthan commented Oct 22, 2018 reply Follow Share 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 2 votes 2 votes altamash commented Oct 22, 2018 reply Follow Share Thanks 0 votes 0 votes Please log in or register to add a comment.