现在有2个表
用户表:customers ,有用户id cust_id,状态 cust_state
订单表:orders,有订单对应用户id,订单信息
现在要求:计算每个用户的订单数量,显示用户名字和状态
使用子查询:
SELECT
CUST_NAME,
CUST_STATE,
(SELECT count(*)
FROM ORDERS
WHERE orders.CUST_ID = customers.cust_id) AS orders
FROM CUSTOMERS
ORDER BY CUST_NAME;
使用内链接:
<