Nonstop Database, HiRDB Version 9 UAP Development Guide
The FROM clause of the SELECT statement is used to retrieve data from two or more tables. The following figure shows, as an example of obtaining a single result from multiple tables, the procedure for creating a table consisting of form numbers and product names for products with fewer than 60 units in stock and fewer than 30 units ordered.
Figure 2-9 Example of retrieval from two tables
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.