UNION ALL | SQL Tutorial and Query Example

Text copied!

UNION ALL


  • UNION ALL syntax in SQL
    SELECT column1, column2, column3, ...
    FROM table1
    WHERE condition1
    UNION ALL
    SELECT column1, column2, column3, ...
    FROM table2
    WHERE condition2;