Return
-
Title
Does Toad support the UNION operator? -
Description
Does Toad support the UNION operator? -
Resolution
Yes the UNION operator works when used in the Editor and ran as a script.
SYNTAX for the UNION operator:
SELECT column(s) FROM table_1
UNION
SELECT column(s) FROM table_2; -
Additional Information
UNION will select automatically select all distinct matches. To select all columns, including duplicates use UNION ALL.
Example:
SELECT column(s) FROM table_1
UNION ALL
SELECT column(s) FROM table_2;