OUTER JOIN

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  December 12, 2003 at 3:47 am

  #81699

  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

  1Server12.5.15.364

  2Server22.5.15.3199

  3dd2.5.15.131

  But for last record it should be 0 as there are no records for dd??

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/

• Dinesh Asanka

  SSChampion

  Points: 11058

  More actions

  December 12, 2003 at 4:02 am

  #485908

  Oh! Got it 🙂

  COUNT(*) is the problem

  COUNT(P.WFS_SERVER_ID )

  
  
  
  

  My Blog: http://dineshasanka.spaces.live.com/