110 likes | 264 Views
Chapter 2 Supplemental Slides. Outer Join Demonstration. Join. Matched rows using the join condition. Conceptual Animation. Table 1 (left). Table 2 (right). Left outer join. Join. Join. Unmatched rows of the left table. Matched rows using the join condition.
E N D
Chapter 2 Supplemental Slides Outer Join Demonstration
Join Matched rows using the join condition Conceptual Animation Table 1 (left) Table 2 (right)
Left outer join Join Join Unmatched rows of the left table Matched rows using the join condition Matched rows using the join condition Conceptual Animation Table 1 (left) Table 2 (right)
Full outer join Left outer join Right outer join Join Join Join Unmatched rows of the left table Matched rows using the join condition Matched rows using the join condition Matched rows using the join condition Unmatched rows of the right table Conceptual Animation Table 1 (left) Table 2 (right)
Full Outer Join Animation Matching rows
Full Outer Join Animation Faculty Full Join Offering OfferNo FacSSN FacName 1111 111-11-1111 JOE 2222 222-22-2222 SUE 3333 111-11-1111 JOE 4444
333-33-3333 SARA Full Outer Join Animation Faculty Full Join Offering OfferNo FacSSN FacName 1111 111-11-1111 JOE 2222 222-22-2222 SUE 3333 111-11-1111 JOE 4444
Left Outer Join Animation Matching rows
Left Outer Join Animation Offering Left Join Faculty OfferNo FacSSN FacName 1111 111-11-1111 JOE 2222 222-22-2222 SUE 3333 111-11-1111 JOE 4444