Monday, March 26, 2012

OUTER JOIN PROBLEM

My SQL Statement as follows:

SELECT S.SessionID,S.SessionName,T.number
FROM Sessions S LEFT OUTER JOIN (SELECT SessionID,COUNT(*) AS number
FROM EventLog
WHERE MachineID = @.machineID
GROUP BY SessionID) AS T
ON S.SessionID = T.SessionID
ORDER BY S.SessionID

The result sets T.number as NULL if there is no record related to SessionName. How to change NULL to ZERO?
Thanks a lot.ISNULL(T.number, 0)|||SELECT S.SessionID,S.SessionName,isnull(T.number,0)

No comments:

Post a Comment