我試圖在我的查詢結果中顯示每個客戶的客戶名字、姓氏和總發票。我錯過了什么？有人可以幫忙嗎？這是桌子的設計：
這是我寫的，但收到此錯誤：“未在預期的位置找到 FROM 關鍵字”
COUNT(INV_NUMBER) AS 'Number of Invoices'
FROM (SELECT CUS_CODE, L.INV_NUMBER AS INV_NUMBER
FROM INVOICE I, LINE L
WHERE I.INV_NUMBER = L.INV_NUMBER
GROUP BY CUS_CODE, L.INV_NUMBER) AS IL
GROUP BY CUS_CODE;```
Desired result: first name, Last name, Total invoices ordered in descending order
uj5u.com熱心網友回復：
您需要通過共同元素 - 客戶代碼連接客戶表和發票表。
SELECT c.cus_fname, c.cus_lname, COUNT (*) AS "Inv Count"
FROM customer c,
invoice i
WHERE c.cus_code = i.cus_code
GROUP BY c.cus_fname, c.cus_lname
ORDER BY 3 DESC
... 的降序？大概是發票的數量。您不能按別名排序，但可以按列位置排序。
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/494496.html