You can combine multiple tables and queries together by using UNION ALL.
Note: UNION will parse, but it will be treated as UNION ALL –ie. duplicate records kept in the returned data set.
Example:
SELECT * FROM table1 UNION ALL SELECT * FROM table2.

  • No labels