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

Timestamp:

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

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

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

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

@@ -16 +16 @@
         $query0 .= " FROM DataSets ";
 
-        $query0 .= " LEFT JOIN Source ON DataSets.fSourceKEY=Source.fSourceKEY ";
-        $query0 .= " LEFT JOIN ObservationMode ON DataSets.fObservationModeKEY=ObservationMode.fObservationModeKEY ";
-        $query0 .= " LEFT JOIN DataSetProcessStatus ON DataSets.fDataSetNumber=DataSetProcessStatus.fDataSetNumber ";
-        $query0 .= " LEFT JOIN Ganymed ON DataSets.fDataSetNumber=Ganymed.fDataSetNumber ";
+        $query0 .= " LEFT JOIN Source USING(fSourceKEY) ";
+        $query0 .= " LEFT JOIN ObservationMode USING(fObservationModeKEY) ";
+        $query0 .= " LEFT JOIN DataSetProcessStatus USING(fDataSetNumber) ";
+        $query0 .= " LEFT JOIN Ganymed USING(fDataSetNumber) ";
 
         if (!empty($_GET["fRunMin"]) && !empty($_GET["fRunMax"]))