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

Timestamp:

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

Author:

Daniela Dorner

Message:

*** empty log message ***

File:

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

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

@@ -14 +14 @@
              "DataSetNumber"  => "fDataSetNumber");
 
-$joins=array("fSequenceFirst" => " LEFT JOIN Star ON Star.fSequenceFirst=Sequences.fSequenceFirst "
-             ."LEFT JOIN Calibration ON Calibration.fSequenceFirst=Sequences.fSequenceFirst",
-             "fRunNumber" => " LEFT JOIN DataCheck ON DataCheck.fRunNumber=RunData.fRunNumber ",
-             "fDataSetNumber" =>" LEFT JOIN Ganymed ON Ganymed.fDataSetNumber=DataSets.fDataSetNumber");
+$joins=array("fSequenceFirst" => " LEFT JOIN Star USING(fSequenceFirst,fTelescopeNumber) "
+             ."LEFT JOIN Calibration USING(fSequenceFirst,fTelescopeNumber) ",
+             "fRunNumber" => " LEFT JOIN DataCheck USING(fRunNumber) ",
+             "fDataSetNumber" =>" LEFT JOIN Ganymed USING(fDataSetNumber) ");
 
 function GetList($host, $user, $pw, $db, $column, $tables)