next up previous
Next: Join types and conditions Up: Joined Relations Previous: Joined Relations


  1. Two given relations: loan and borrower.

    Figure 4.1:   The loan and borrower relations.

  2. inner join:

     loan inner join borrower on =

    Notice that the loan# will appear twice in the inner joined relation.

    Figure 4.2:   Result of loan inner join borrower.

  3. left outer join:

     loan left outer join borrower on =

    Figure 4.3:   Result of loan left outer join borrower.

  4. natural inner join:

     loan natural inner join borrower

    Figure 4.4:   Result of loan natural inner join borrower.

Osmar Zaiane
Fri May 22 19:39:12 PDT 1998