Changeset 11075 for trunk/ippTools/src/chiptool.c
- Timestamp:
- Jan 12, 2007, 12:24:34 PM (19 years ago)
- File:
-
- 1 edited
-
trunk/ippTools/src/chiptool.c (modified) (5 diffs)
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippTools/src/chiptool.c
r11034 r11075 99 99 "SELECT" 100 100 " p2PendingImfile.*," 101 " raw ScienceExp.camera"101 " rawExp.camera" 102 102 " FROM p2PendingImfile" 103 103 " JOIN p2PendingExp" 104 104 " USING(exp_tag)" 105 " JOIN raw ScienceExp"105 " JOIN rawExp" 106 106 " USING(exp_tag)" 107 107 " LEFT JOIN p2Mask" … … 353 353 "SELECT" 354 354 " p2ProcessedImfile.*," 355 " raw ScienceExp.camera"355 " rawExp.camera" 356 356 " FROM p2ProcessedImfile" 357 " JOIN raw ScienceExp"357 " JOIN rawExp" 358 358 " USING(exp_tag)" 359 359 " WHERE " … … 554 554 // where exp_tag is not in p2PendingImfile 555 555 // where the number of entries in p2ProccessedImfile matches the .imfiles 556 // entry in raw ScienceExp556 // entry in rawExp 557 557 psString query = psStringCopy( 558 558 "SELECT DISTINCT" 559 559 " p2PendingExp.*," 560 " raw ScienceExp.imfiles,"560 " rawExp.imfiles," 561 561 " p2ProcessedImfile.class_id" 562 562 " FROM p2PendingExp" 563 " JOIN raw ScienceExp"564 " ON p2PendingExp.exp_tag = raw ScienceExp.exp_tag"563 " JOIN rawExp" 564 " ON p2PendingExp.exp_tag = rawExp.exp_tag" 565 565 " LEFT JOIN p2ProcessedExp" 566 566 " ON p2PendingExp.exp_tag = p2ProcessedExp.exp_tag" … … 575 575 " GROUP BY" 576 576 " p2PendingExp.exp_tag" 577 " HAVING raw ScienceExp.imfiles = COUNT(p2ProcessedImfile.class_id)"577 " HAVING rawExp.imfiles = COUNT(p2ProcessedImfile.class_id)" 578 578 ); 579 579 … … 773 773 pendingExp->p1_version, 774 774 pendingExp->p2_version, 775 pendingExp->label, 776 0 // fault code 775 pendingExp->label 777 776 ); 778 777 }
Note:
See TracChangeset
for help on using the changeset viewer.
