我試圖運行這個查詢：
SELECT
M.Desc AS LevelDescription,
COUNT(M.Id) AS Counts
FROM(M.Id)
碩士水平M
LEFT JOIN
Counsent C ON (M.Id = C.LevelId)
GROUP BY C.LevelId
M.Desc, M.Id, C.LevelId, C.ProcedureId, C.IsAccepts
HAVING[/span
(C.IsAccepts = 'Yes'/span>)
AND (C.ProcedureId = 3)
AND (M.Id IN (1, 2, 3, 4)
它只顯示非零的計數，我想要的結果是這樣的：
我希望有人能幫助我。
uj5u.com熱心網友回復：
我認為HAVING子句中的限制屬于連接中相應的ON子句：
SELECTM. Desc AS LevelDescription, COUNT(C.LevelId) AS Counts
FROM Master_Levels M
LEFT JOIN Counsent C
ON M.Id = C.LevelId AND C。 ProcedureId = 3 AND C.IsAccepts = 'Yes'
WHERE M.Id IN （1, 2, 3, 4)
GROUP BY M.Desc;
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/332203.html
標籤：