Examples

1. Two given relations: loan and borrower.

    
   Figure 4.1:   The loan and borrower relations.
   

2. inner join:

    loan inner join borrower on loan.loan# = borrower.loan#
   
   

   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 loan.loan# = borrower.loan#
   
   

    
   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.