Oracle9i™ Development by Example

Table Join Conditions

This section covers getting data from more than one table at a time (joins). Joins are used to combine columns from two or more tables. Figure 7.16 shows a simple join between EMP and DEPT. Notice that the table name is specified with each duplicate name of columns between the two tables (see the WHERE clause of Figure 7.16). Figure 7.17 shows the same query but using a table name 'alias.' This alias can be used anyplace that further qualification is necessary (columns with the same name in different tables).

Figure 7.16. Simple table join example.

Figure 7.17. Simple table join with table name qualification example.

Figure ...