SELECT
statement fetches data from a table and predictions from a model.
Here we go over example of selecting data from tables of connected data sources. To learn how to select predictions from a model, visit this page.
UNION
and UNION ALL
operators. It this case, every subselect from union will be fetched and merged to one result-set on MindsDB side.