题解 | 组合 Products 表中的产品名称和 Customers 表中的顾客名称
组合 Products 表中的产品名称和 Customers 表中的顾客名称
https://www.nowcoder.com/practice/461077c0ba0f473abecf5ee79c632acd
# 放第一个select SELECT cust_name FROM Customers UNION SELECT prod_name FROM Products ORDER BY cust_name # 使用别名 SELECT prod_name AS cust_name FROM Products UNION SELECT cust_name FROM Customers ORDER BY cust_name
