select prod_name
from Products
union all
select cust_name as prod_name
from Customers
order by prod_name;

使用union all拼接两个查询结果