Changeset 9105 for trunk/MagicSoft/Mars/datacenter/db/runinfo.php
- Timestamp:
- 08/06/08 16:13:23 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/MagicSoft/Mars/datacenter/db/runinfo.php
r9052 r9105 59 59 $query0 .= " FROM RunData "; 60 60 61 $query0 .= " LEFT JOIN RunProcessStatus ON RunData.fRunNumber=RunProcessStatus.fRunNumber";61 $query0 .= " LEFT JOIN RunProcessStatus USING(fRunNumber,fTelescopeNumber,fFileNumber) "; 62 62 63 63 foreach ($_GET as $key => $element) … … 68 68 { 69 69 if ($_GET["fSourceName"]!="On") 70 $query0 .= " LEFT JOIN Source ON Sequences.fSourceKEY=Source.fSourceKEY";70 $query0 .= " LEFT JOIN Source USING(fSourceKEY) "; 71 71 $query0 .= " WHERE fTest='no'"; 72 72 }
Note:
See TracChangeset
for help on using the changeset viewer.