题解 | #纠错4#
纠错4
http://www.nowcoder.com/practice/bde1451b91084c8cab467387a0e0969c
SELECT cust_name, cust_contact, cust_email FROM Customers UNION SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'IL' and cust_state = 'MI' ORDER BY cust_name;
或者 SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'MI' UNION SELECT cust_name, cust_contact, cust_email FROM Customers WHERE cust_state = 'IL' ORDER BY cust_name;