Changeset 35297 for trunk/ippTools/share

Timestamp:

Mar 11, 2013, 2:05:10 PM (13 years ago)

Author:

bills

Message:

implement various relGroup related functions

Location:

trunk/ippTools/share

Files:

• releasetool_definerelgroup_select_exp_lap.sql (modified) (1 diff)
• releasetool_pendingrelgroup.sql (modified) (1 diff)

trunk/ippTools/share/releasetool_definerelgroup_select_exp_lap.sql

@@ -1 +1 @@
 SELECT relExp.relexp_id
-FROM relGroup JOIN lapRun USING(lap_id)
+FROM relGroup 
+    JOIN lapRun USING(lap_id)
+    JOIN lapExp USING(lap_id)
     JOIN relExp using(rel_id, exp_id)
 WHERE relExp.group_id = 0

trunk/ippTools/share/releasetool_pendingrelgroup.sql

@@ -1 @@
-SELECT relGroup.*
+SELECT 
+    relGroup.*,
+    ippRelease.release_name
 FROM relGroup
     JOIN ippRelease USING(rel_id)