skip to main content
Supported SQL Functionality : Set Operators
  

Try DataDirect Drivers Now

Set Operators

Supported, with the following Entry SQL level restrictions:
*UNION is not supported.
Therefore, the following query fails:
SELECT * FROM t1 UNION SELECT * FROM t2
*UNION ALL is supported.
Therefore, the following query works:
SELECT * FROM t1 UNION ALL SELECT * FROM t2
In addition, INTERSECT or EXCEPT are not supported.