ช่วยดู SUBQUERY คับว่าตรงไหนผิด ตอนรันแยกใช้ได้ แต่พอเป็น sub query ไม่ได้อ่ะคับ

SELECT  Count(M.MatchID)
FROM Steward AS S, [Match] AS M
WHERE S.MatchID=M.MatchID AND S.StewardAllocation='YES' AND S.ExpType='No'
GROUP BY M.MatchID;

SELECT MatchID, MatchType, MatchDate, NoOfStewardExp, NoOfStewardNonExp, 
(SELECT Count(M.MatchID) FROM Steward AS S, Match AS M WHERE S.MatchID=M.MatchID AND S.StewardAllocation='YES' AND S.ExpType='YES' ) AS ExpStewardAllocated, 
(SELECT Count(M.MatchID) FROM Steward AS S, Match AS M WHERE S.MatchID=M.MatchID AND S.StewardAllocation='YES' AND S.ExpType='No' ) AS NonExpStewardAllocated 
FROM Match WHERE MatchType='Home' ORDER BY MatchID ASC;