When done with JOIN, WHERE, and ORDER BY, you can save your statement locally.
Example based on the scenarios presented in the previous topics:
Invoice Upper Form Data
|
|
|
|
---|---|---|---|
| |||
| |||
| |||
| |||
| |||
| |||
Invoice Creator Data
|
|
|
|
| |||
| |||
Project Data
|
| AS ProjectName, |
|
| AS ProjectNumber, | ||
| AS ProjectStartDate, | ||
| AS ProjectEndDate, | ||
| AS InitialBudget, | ||
| AS RevisedBudget | Note: No comma ( , ) on the last line of the SELECT section. | |
|
| List of tables we’re getting data from, including the fields we’re using to match up the tables.
| |
|
| ||
| |||
| |||
| |||
|
| Filtering of the data | |
|
| Sorting of the data
| |
|
Legal Notices
Copyright © 2016, 2018,
Oracle and/or its affiliates. All rights reserved.
Last Published Wednesday, March 28, 2018