SELECT S.WFS_SERVER_ID, S.SERVERNAME, S.IPADDRESS, COUNT(*) AS Expr1
FROM WFS_PROCESS P RIGHT OUTER JOIN
WFS_SERVERS S ON P.WFS_SERVER_ID = S.WFS_SERVER_ID
GROUP BY S.SERVERNAME, S.IPADDRESS, S.WFS_SERVER_ID
ORDER BY S.WFS_SERVER_ID
this returning folowinf records
1 Server1 2.5.15.3 64
2 Server2 2.5.15.31 99
3 dd 2.5.15.13 1
But for last record it should be 0 as there are no records for dd??
My Blog: http://dineshasanka.spaces.live.com/