Changeset 31587 for branches/eam_branches/ipp-20110505/ippTools/share/laptool_definerun.sql

Timestamp:

May 29, 2011, 11:26:31 AM (15 years ago)

Author:

eugene

Message:

merging changes from trunk

File:

• branches/eam_branches/ipp-20110505/ippTools/share/laptool_definerun.sql (modified) (2 diffs)

branches/eam_branches/ipp-20110505/ippTools/share/laptool_definerun.sql

@@ -1 @@
-SELECT want.exp_id, have.chip_id, false as private, true as active, false as pairwise
+SELECT DISTINCT want.exp_id, have.chip_id, false as private, true as active, false as pairwise
   FROM
   (SELECT exp_id FROM rawExp 
@@ -8 +8 @@
   ) AS want
   LEFT JOIN 
-  (SELECT *
+  (SELECT exp_id,MAX(chip_id) AS chip_id
      FROM lapExp 
      where private IS FALSE