题解 | 组合 Products 表中的产品名称和 Customers 表中的顾客名称
组合 Products 表中的产品名称和 Customers 表中的顾客名称
https://www.nowcoder.com/practice/461077c0ba0f473abecf5ee79c632acd
# select prod_name from Products # union all # select cust_name as prod_name from Customers # order by prod_name ASC; # select prod_name from Products # union all # select cust_name from Customers # order by 1 ASC; select prod_name from Products union all select cust_name from Customers order by prod_name ASC;
三奇智元机器人科技有限公司公司福利 74人发布