You can specify result tables which select data from two or more base tables, two or more views, or even other result tables.
One method is the join, which derives a result table that includes the specified columns from two or more base tables, views, or other result tables.
Another method is the union, which produces a result table that is actually a set derived from two or more result tables. This method, using the UNION operator, eliminates duplicate rows in the result table. To retain duplicate rows in the set, specify UNION ALL.
|
Copyright © 2014 CA.
All rights reserved.
|
|