How to display 0 in a count query if no records?

• Hans Lindgren

  SSChampion

  Points: 10496

  More actions

  June 17, 2005 at 9:47 am

  #566488

  Hello!

  I guess changing a couple of INNER JOINS to LEFT JOINS (or making them subqueries) and removing the WHERE     (dbo.analgroup.sys_analgroup IS NOT NULL) or moving it into a ON clause on a LEFT JOIN clause. Though by doing your INNER JOIN with  dbo.analgroup you also make your where clause unneccessary (since the inner join will eliminat the rows with NULL in the joining field)...

  //Hanslindgren

• Gabor Nyul

  SSCrazy Eights

  Points: 9459

  More actions

  June 20, 2005 at 6:34 am

  #566684

  Andrew,

  The basic idea is the list every items of your main table (analgroup) and optionally the records ot other tables by LEFT joining them

  
  
  Bye
  Gabor