Index: lams_common/src/java/org/lamsfoundation/lams/learningdesign/dao/hibernate/GroupDAO.java
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/learningdesign/dao/hibernate/GroupDAO.java,v
diff -u -r1.10 -r1.11
--- lams_common/src/java/org/lamsfoundation/lams/learningdesign/dao/hibernate/GroupDAO.java	23 Oct 2006 23:57:59 -0000	1.10
+++ lams_common/src/java/org/lamsfoundation/lams/learningdesign/dao/hibernate/GroupDAO.java	9 Jan 2012 08:40:58 -0000	1.11
@@ -44,8 +44,8 @@
 public class GroupDAO extends BaseDAO implements IGroupDAO {
 
 	private final static String NUM_GROUPS = "select count(*) from "
-		+ Group.class.getName() + " group "
-		+ " where group.users.userId = :userID";
+		+ Group.class.getName() + " g join g.users u"
+		+ " where u.userId = :userID";
 
 	/* (non-Javadoc)
 	 * @see org.lamsfoundation.lams.learningdesign.dao.interfaces.IGroupDAO#getGroupById(java.lang.Long)