Explore BrainMass

Difference between JOIN, equiJOIN, outer JOIN using example

List the rows in each of the joined tables. Use the small database shown in Figure Q3.5 to illustrate the difference between a natural JOIN, an equiJOlN, and an outer JOIN.

(See attached file for data)


Solution Summary

This solution provides the following for a database: natural JOIN, an equiJOIN, and an outer JOIN.