Changeset 9106 for trunk/MagicSoft/Mars/datacenter/db/datacheck.php

Timestamp:

08/06/08 16:52:46 (16 years ago)

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

• trunk/MagicSoft/Mars/datacenter/db/datacheck.php (modified) (1 diff)

trunk/MagicSoft/Mars/datacenter/db/datacheck.php

@@ -76 +76 @@
         $query0 .= " FROM RunData ";
 
-        $query0 .= " LEFT JOIN RunProcessStatus ON RunData.fRunNumber=RunProcessStatus.fRunNumber ";
-        $query0 .= " LEFT JOIN DataCheck ON DataCheck.fRunNumber=RunData.fRunNumber ";
-        $query0 .= " LEFT JOIN RunType ON RunType.fRunTypeKEY=RunData.fRunTypeKEY ";
+        $query0 .= " LEFT JOIN RunProcessStatus USING(fRunNumber,fTelescopeNumber,fFileNumber) ";
+        $query0 .= " LEFT JOIN DataCheck USING(fRunNumber) ";
+        $query0 .= " LEFT JOIN RunType USING(fRunTypeKEY) ";
 
         foreach ($checkwhere as $key => $element)