Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Two or more SQL SELECT queries.
  • The source tables in the SQL SELECT statements must have the same number of columns.
  • The column data types of each of the source tables also need to match.

Limitations

...

None.

Known Issues

Multiexcerpt include macro
nameME_ELT_KI_Underscore_Refs
pageELT Snap Pack

Snap Input and Output

Input/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream SnapsDescription
Input 

Document

  • Min: 2
  • Max: No limit
  • ELT Select
  • ELT Intersect
  • ELT Copy
The SQL SELECT statements that you want to combine with a UNION DISTINCT or UNION ALL operator.
Output

Document

  • Min: 1
  • Max: 1
  • ELT Insert-Select
  • ELT Limit

The modified SQL query with a UNION DISTINCT or UNION ALL operator. 

...