UNION ALL
UNION ALL glues two result sets together and keeps every row. Both sides need the same number of columns, with compatible types.
task
One list of all customer emails and all product names, with a second column saying which kind each is ('customer' or 'product').