計算出每筆訂單有幾筆商品
SELECT
user_order_A.id,
user_order_A.name,
COUNT(user_order_A.id)
FROM user_order_A
JOIN products_table
ON(user_order_A.id= products_table.order_id)
GROUP BY user_order_A.id;
結果:
其它文章