Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 18319)
+++ trunk/ippTools/share/Makefile.am	(revision 18328)
@@ -74,6 +74,8 @@
 	pztool_revert_downloadimfile_faults.sql \
 	pztool_revert_fileset_faults.sql \
+	regtool_create_dup_table.sql \
 	regtool_pendingexp.sql \
 	regtool_pendingimfile.sql \
+	regtool_populate_dup_table.sql \
 	regtool_processedexp.sql \
 	regtool_processedimfile.sql \
Index: trunk/ippTools/share/regtool_create_dup_table.sql
===================================================================
--- trunk/ippTools/share/regtool_create_dup_table.sql	(revision 18328)
+++ trunk/ippTools/share/regtool_create_dup_table.sql	(revision 18328)
@@ -0,0 +1,2 @@
+CREATE TEMPORARY TABLE duplicate (exp_id BIGINT, PRIMARY KEY(exp_id))
+ENGINE=MEMORY
Index: trunk/ippTools/share/regtool_populate_dup_table.sql
===================================================================
--- trunk/ippTools/share/regtool_populate_dup_table.sql	(revision 18328)
+++ trunk/ippTools/share/regtool_populate_dup_table.sql	(revision 18328)
@@ -0,0 +1,13 @@
+INSERT INTO duplicate
+SELECT exp_id FROM
+    (
+        SELECT
+        MAX(exp_id) AS exp_id,
+--            tmp_exp_name,
+--            tmp_camera,
+--            tmp_telescope,
+        count(exp_id) AS count
+        FROM newExp
+        GROUP BY tmp_exp_name, tmp_camera, tmp_telescope
+        HAVING count > 1
+    ) as Foo