MashZone NextGen 10.2 | Appendix | Legacy Presto components | MashZone NextGen Analytics | RAQL Queries | Multi-DataSet Operations
 
Multi-DataSet Operations
Clause
Column Expression
Example
[inner] join
query on condition
To join the columns of each row from two or more queries based on the specified condition. This is an inner join where joined results contain only those rows that have matches from all the queries involved in the join.
query using columns-list
To join the columns of each row from two or more queries based on matches for the column(s) specified. Each query result must contain columns that match this list.
natural join
query
To join the columns of each row from two or more queries based on equivalent values in the columns in query results with matching names. Columns with matching names must contain data of the same type.
cross join
query
Creates a Cartesian product matching each row from one query with every row from one or more additional queries and including all the columns.
union
[distinct] query
Merges the results of two of more queries including every row. Each query must contain the same columns with the same datatype. The distinct keyword is optional as duplicate rows are removed from the result by default.
all query
Merges the results of two of more queries including every row (duplicates are not removed). Each query must contain the same columns with the same datatype.
intersect
[distinct] query
Includes each row from the results of the first query that has a matching row in the results of the second query. The distinct keyword is optional as the default behavior is to remove duplicate rows from the first query results.
all query
Includes all rows, including duplicates, from the results of the first query that have a matching row in the results for the second query.
except
[distinct] query
Includes each row from the first query that does not match any row in the second query. The distinct keyword is optional as the default behavior is to remove duplicate rows from the first query results.
minus
except
all query
Includes all rows, including duplicates, that do not match any row in the second query.
minus

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release