Changeset 9105 for trunk/MagicSoft/Mars/datacenter/db/sequinfo.php
- Timestamp:
- 08/06/08 16:13:23 (16 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/MagicSoft/Mars/datacenter/db/sequinfo.php
r9052 r9105 72 72 $query0 .= " FROM " . $fromtable; 73 73 74 $query0 .= " LEFT JOIN SequenceProcessStatus ON Sequences.fSequenceFirst=SequenceProcessStatus.fSequenceFirst";75 $query0 .= " LEFT JOIN Calibration ON Sequences.fSequenceFirst=Calibration.fSequenceFirst";76 $query0 .= " LEFT JOIN Star ON Sequences.fSequenceFirst=Star.fSequenceFirst";74 $query0 .= " LEFT JOIN SequenceProcessStatus USING(fSequenceFirst,fTelescopeNumber) "; 75 $query0 .= " LEFT JOIN Calibration USING(fSequenceFirst,fTelescopeNumber) "; 76 $query0 .= " LEFT JOIN Star USING(fSequenceFirst,fTelescopeNumber) "; 77 77 78 78 // foreach ($_GET as $key => $element) … … 87 87 { 88 88 if ($_GET["fSourceName"]!="On") 89 $query0 .= " LEFT JOIN Source ON Sequences.fSourceKEY=Source.fSourceKEY";89 $query0 .= " LEFT JOIN Source ON USING(fSourceKEY) "; 90 90 $query0 .= " WHERE fTest='no'"; 91 91 }
Note:
See TracChangeset
for help on using the changeset viewer.