题解 | #纠错4#

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;