How Many Comparisons Do You Need?
When
using Oracle syntax for table joins, a query on data from more than two tables
must contain the right number of equality operations to avoid a Cartesian
product. To avoid confusion, use this simple rule: If the number of tables to be
joined equals N, include at least N-1 equality conditions in the select
statement so that each common column is referenced at least once.
