题解 | 组合 Products 表中的产品名称和 Customers 表中的顾客名称
# UNION---自动删除重复行;UNION ALL---保留重复行 SELECT p.prod_name FROM Products AS p UNION SELECT c.cust_name AS prod_name FROM Customers AS c ORDER BY prod_name;
# UNION---自动删除重复行;UNION ALL---保留重复行 SELECT p.prod_name FROM Products AS p UNION SELECT c.cust_name AS prod_name FROM Customers AS c ORDER BY prod_name;
相关推荐