【Oracle 官方技术支持】Les04_多表查询.ppt

Creating Cross Joins The example on the slide gives the same results as the following: SELECT last_name, department_name FROM employees, departments; … Creating Natural Joins It was not possible to do a join without explicitly specifying the columns in the corresponding tables in prior releases of Oracle. In Oracle9i it is possible to let the join be completed automatically based on columns in the two tables which have matching data types and names, using the keywords NATURAL JOIN keywords. Note: The join can happen only on columns having the same names and data types in both the