MYSQL必知必会第14章SQL语句

SELECT cust_name,cust_contact FROM customers WHERE cust_id IN(

SELECT cust_id FROM orders WHERE order_num IN(

SELECT order_num FROM orderitems WHERE prod_id IN(

SELECT prod_id FROM orderitems WHERE prod_id IN ('TNT2')

)

)

);

/***********************************************************************************************/

SELECT cust_name,cust_state ,(
  SELECT COUNT(*) FROM orders WHERE customers.cust_id = orders.cust_id
 ) AS orderNums
 FROM customers;

/***********************************************************************************************/