The `UNION` operator concatenates two query results. Both answer sets must have the same number of columns and data types for aligned columns. Simply put `UNION` between the two queries. For example, to get a table of values by category and a total row
```SQL
SELECT category, sum(value)
FROM products
GROUP BY category
UNION
SELECT 'Total', sum(value)
FROM products
ORDER BY 1;
```