组合2个表中的名称
组合 Products 表中的产品名称和 Customers 表中的顾客名称
https://www.nowcoder.com/practice/461077c0ba0f473abecf5ee79c632acd
select
prod_name
from
Products
union
select
cust_name as prod_name
from
Customers
order by
prod_name
组合 Products 表中的产品名称和 Customers 表中的顾客名称
https://www.nowcoder.com/practice/461077c0ba0f473abecf5ee79c632acd
select
prod_name
from
Products
union
select
cust_name as prod_name
from
Customers
order by
prod_name
相关推荐