Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 34913)
+++ trunk/ippTools/share/Makefile.am	(revision 34933)
@@ -464,4 +464,5 @@
 	releasetool_listsurvey.sql \
 	releasetool_listrelease.sql \
-	releasetool_listrelexp.sql
+	releasetool_listrelexp.sql \
+	releasetool_definerelexp.sql
 
Index: trunk/ippTools/share/releasetool_definerelexp.sql
===================================================================
--- trunk/ippTools/share/releasetool_definerelexp.sql	(revision 34933)
+++ trunk/ippTools/share/releasetool_definerelexp.sql	(revision 34933)
@@ -0,0 +1,19 @@
+SELECT
+    ippRelease.rel_id,
+    ippRelease.releaseName,
+    rawExp.exp_name,
+    rawExp.filter,
+    rawExp.dateobs,
+    rawExp.exp_id,
+    camRun.chip_id,
+    camRun.cam_id,
+    camProcessedExp.zpt_obs,
+    camProcessedExp.zpt_stdev
+FROM ippRelease
+JOIN camRun
+JOIN camProcessedExp USING(cam_id)
+JOIN chipRun USING(chip_id)
+JOIN rawExp USING(exp_id)
+LEFT JOIN relExp AS previousrelexp USING(exp_id, rel_id) 
+
+WHERE previousrelexp.relexp_id IS NULL
Index: trunk/ippTools/share/releasetool_listrelexp.sql
===================================================================
--- trunk/ippTools/share/releasetool_listrelexp.sql	(revision 34913)
+++ trunk/ippTools/share/releasetool_listrelexp.sql	(revision 34933)
@@ -1,4 +1,36 @@
-SELECT * 
+SELECT
+    relexp_id,
+    releaseName,
+    relExp.state,
+    rel_id,
+    survey.surveyName,
+    exp_name,
+    relExp.flags,
+    relExp.zpt_obs,
+    relExp.zpt_stdev,
+    relExp.path_base,
+    relExp.registered,
+    relExp.time_stamp,
+    exp_id,
+    chip_id,
+    chipRun.state as chip_state,
+    cam_id,
+    camRun.state as cam_state,
+    camProcessedExp.path_base as cam_path_base,
+    warp_id,
+    warpRun.state as warp_state,
+    rawExp.filter,
+    rawExp.dateobs,
+    TRUNCATE(DEGREES(rawExp.ra), 4) AS radeg,
+    TRUNCATE(DEGREES(rawExp.decl), 4) AS decdeg,
+    rawExp.object,
+    rawExp.comment
 FROM relExp 
-JOIN release USING(rel_id) 
-JOIN survey using(surveyID)
+JOIN ippRelease USING(rel_id) 
+JOIN survey USING(surveyID)
+JOIN rawExp using(exp_id)
+JOIN chipRun using(chip_id, exp_id)
+JOIN camRun using(cam_id, chip_id)
+JOIN camProcessedExp using(cam_id)
+JOIN fakeRun using(cam_id)
+JOIN warpRun using(fake_id)