Changeset 24788 for trunk/ippTools/share/receivetool_pendingfileset.sql
- Timestamp:
- Jul 14, 2009, 1:56:39 PM (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippTools/share/receivetool_pendingfileset.sql
r24787 r24788 1 1 SELECT * 2 2 FROM receiveFileset 3 WHERE state = 'reg' 4 AND fault = 0 3 JOIN receiveSource USING(source_id) 4 LEFT JOIN receiveFile USING(fileset_id) 5 WHERE receiveFileset.state = 'reg' 6 AND receiveFileset.fault = 0 7 AND receiveFile.fileset_id IS NULL
Note:
See TracChangeset
for help on using the changeset viewer.
