Monday, January 4, 2010

Creating Natural JoinsCreating Natural Joins


• The NATURAL JOIN clause is based on all columns in the two tables that have the same name.


• It selects rows from the two tables that have equal values in all matched columns.

• If the columns having the same names have different data types, an error is returned.