Changeset 9310

Timestamp:

Oct 5, 2006, 12:11:49 PM (20 years ago)

Author:

jhoblitt

Message:

fix -pendingexp

File:

• trunk/ippTools/src/camtool.c (modified) (1 diff)

trunk/ippTools/src/camtool.c

@@ -52 +52 @@
     PS_ASSERT_PTR_NON_NULL(config, false);
 
-    psString query = psStringCopy("SELECT * FROM p3PendingExp");
+    psString query = psStringCopy(
+            "SELECT * FROM p3PendingExp"
+            " LEFT JOIN p3ProcessedExp"
+            "   USING(exp_tag)"
+            " WHERE"
+            "   p3ProcessedExp.exp_tag IS NULL"
+    );
 
     if (config->where) {
-        psString whereClause = psDBGenerateWhereSQL(config->where, NULL);
+        psString whereClause = psDBGenerateWhereConditionSQL(config->where, NULL);
         psStringAppend(&query, " %s", whereClause);
         psFree(whereClause);