The FROM clause of the SELECT statement is used to retrieve data from two or more tables. In the example in Figure 2-9, a single set of results is obtained from two tables. The common PCODE column, indicating product code, is used to join the tables STOCK and ORDER. Here, a table consisting of form numbers and product names is created for products with fewer than 60 units in stock and fewer than 30 units ordered.

Figure 2-9 Example of retrieval from two tables