Changeset 21413 for trunk/ippTools/share/pstamptool_pendingreq.sql

Timestamp:

Feb 6, 2009, 5:49:00 PM (17 years ago)

Author:

bills

Message:

include pstampDataStore..outProduct in pending request data

File:

• trunk/ippTools/share/pstamptool_pendingreq.sql (modified) (1 diff)

trunk/ippTools/share/pstamptool_pendingreq.sql

@@ +1 @@
+-- postage stamp requests ready for download and parsing
 SELECT
- *
+ pstampRequest.*,
+ pstampDataStore.outProduct as ds_outProduct
  FROM pstampRequest
- WHERE state = 'new'
+ LEFT JOIN pstampDataStore
+    USING(ds_id)
+ WHERE pstampRequest.state = 'new'