Index: trunk/ippTools/src/camtool.c
===================================================================
--- trunk/ippTools/src/camtool.c	(revision 11138)
+++ trunk/ippTools/src/camtool.c	(revision 11572)
@@ -106,6 +106,6 @@
 
     if (config->where) {
-        psString whereClause = psDBGenerateWhereConditionSQL(config->where, NULL);
-        psStringAppend(&query, " %s", whereClause);
+        psString whereClause = psDBGenerateWhereConditionSQL(config->where, "p3PendingExp");
+        psStringAppend(&query, " AND %s", whereClause);
         psFree(whereClause);
     }
@@ -169,8 +169,8 @@
             "   rawExp.workdir"   
             " FROM p3PendingExp"
+            " JOIN p2ProcessedImfile"
+            "   USING(exp_tag, p2_version)"
             " JOIN rawExp"
             "   USING(exp_tag)"
-            " JOIN p2ProcessedImfile"
-            "   USING(exp_tag, p2_version)"
             " LEFT JOIN p3ProcessedExp"
             "   USING(exp_tag)"
@@ -480,5 +480,5 @@
     if (config->where) {
         psString whereClause = psDBGenerateWhereConditionSQL(config->where, NULL);
-        psStringAppend(&query, " %s", whereClause);
+        psStringAppend(&query, " AND %s", whereClause);
         psFree(whereClause);
     }
