=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/dataanalysis/jdbc/JdbcDataAnalysisStore.java'
--- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/dataanalysis/jdbc/JdbcDataAnalysisStore.java	2010-11-25 08:40:35 +0000
+++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/dataanalysis/jdbc/JdbcDataAnalysisStore.java	2011-01-20 06:56:43 +0000
@@ -147,7 +147,7 @@
             "FROM period AS pe " +
             "JOIN periodtype AS pt ON (pe.periodtypeid = pt.periodtypeid) " +
             "WHERE periodid IN (" + periodIds + ") " +
-            "AND periodtypeid='" + dataElement.getPeriodType().getId() + "' " +
+            "AND pt.periodtypeid='" + dataElement.getPeriodType().getId() + "' " +
             "AND periodid NOT IN ( " +
                 "SELECT periodid FROM datavalue " +
                 "WHERE dataelementid='" + dataElement.getId() + "' " +