Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 23740)
+++ trunk/ippTools/share/Makefile.am	(revision 23742)
@@ -82,4 +82,7 @@
      difftool_definewarpwarp_insert.sql \
      difftool_donecleanup.sql \
+     difftool_export_input_skyfile.sql \
+     difftool_export_run.sql \
+     difftool_export_skyfile.sql \
      difftool_inputskyfile.sql \
      difftool_pendingcleanuprun.sql \
@@ -170,4 +173,7 @@
      stacktool_definebyquery_test.sql \
      stacktool_donecleanup.sql \
+     stacktool_export_input_skyfile.sql \
+     stacktool_export_run.sql \
+     stacktool_export_sum_skyfile.sql \
      stacktool_find_complete_warps.sql \
      stacktool_inputskyfile.sql \
Index: trunk/ippTools/share/difftool_export_input_skyfile.sql
===================================================================
--- trunk/ippTools/share/difftool_export_input_skyfile.sql	(revision 23742)
+++ trunk/ippTools/share/difftool_export_input_skyfile.sql	(revision 23742)
@@ -0,0 +1,1 @@
+SELECT diffInputSkyfile.* FROM diffInputSkyfile
Index: trunk/ippTools/share/difftool_export_run.sql
===================================================================
--- trunk/ippTools/share/difftool_export_run.sql	(revision 23742)
+++ trunk/ippTools/share/difftool_export_run.sql	(revision 23742)
@@ -0,0 +1,1 @@
+SELECT diffRun.* from diffRun
Index: trunk/ippTools/share/difftool_export_skyfile.sql
===================================================================
--- trunk/ippTools/share/difftool_export_skyfile.sql	(revision 23742)
+++ trunk/ippTools/share/difftool_export_skyfile.sql	(revision 23742)
@@ -0,0 +1,1 @@
+SELECT diffSkyfile.* FROM diffSkyfile
Index: trunk/ippTools/share/disttool_toadvance.sql
===================================================================
--- trunk/ippTools/share/disttool_toadvance.sql	(revision 23740)
+++ trunk/ippTools/share/disttool_toadvance.sql	(revision 23742)
@@ -126,14 +126,14 @@
 UNION
 -- diff stage
-SELECT DISTINCT
+SELECT
     distRun.dist_id,
     stage,
     stage_id,
     outroot,
-    label,
+    distRun.label,
     clean
     FROM distRun
     JOIN diffSkyfile
-        ON distRun.dist_id = diffSkyfile.diff_id
+        ON stage_id = diffSkyfile.diff_id
     LEFT JOIN distComponent
         ON distRun.dist_id = distComponent.dist_id
Index: trunk/ippTools/share/stacktool_export_input_skyfile.sql
===================================================================
--- trunk/ippTools/share/stacktool_export_input_skyfile.sql	(revision 23742)
+++ trunk/ippTools/share/stacktool_export_input_skyfile.sql	(revision 23742)
@@ -0,0 +1,1 @@
+SELECT stackInputSkyfile.* FROM stackInputSkyfile
Index: trunk/ippTools/share/stacktool_export_run.sql
===================================================================
--- trunk/ippTools/share/stacktool_export_run.sql	(revision 23742)
+++ trunk/ippTools/share/stacktool_export_run.sql	(revision 23742)
@@ -0,0 +1,1 @@
+SELECT stackRun.* from stackRun
Index: trunk/ippTools/share/stacktool_export_sum_skyfile.sql
===================================================================
--- trunk/ippTools/share/stacktool_export_sum_skyfile.sql	(revision 23742)
+++ trunk/ippTools/share/stacktool_export_sum_skyfile.sql	(revision 23742)
@@ -0,0 +1,1 @@
+SELECT stackSumSkyfile.* FROM stackSumSkyfile
Index: trunk/ippTools/src/disttool.c
===================================================================
--- trunk/ippTools/src/disttool.c	(revision 23740)
+++ trunk/ippTools/src/disttool.c	(revision 23742)
@@ -96,6 +96,7 @@
     PXOPT_LOOKUP_S64(stage_id, config->args, "-stage_id",  true, false);
     PXOPT_LOOKUP_STR(outroot, config->args, "-outroot", true, false);
+    PXOPT_LOOKUP_S64(target_id, config->args, "-target_id",  true, false);
+
     // optional
-    PXOPT_LOOKUP_S64(target_id, config->args, "-target_id",  true, false);
     PXOPT_LOOKUP_BOOL(clean, config->args, "-clean", false);
     PXOPT_LOOKUP_BOOL(no_magic, config->args, "-no_magic", false);
Index: trunk/ippTools/src/stacktool.c
===================================================================
--- trunk/ippTools/src/stacktool.c	(revision 23740)
+++ trunk/ippTools/src/stacktool.c	(revision 23742)
@@ -1253,4 +1253,11 @@
       return true;
     }
+      // we must write the export table in non-simple (true) format
+    if (!ippdbPrintMetadatas(f, output, tables[i].tableName, true)) {
+        psError(PS_ERR_UNKNOWN, false, "failed to print array");
+        psFree(output);
+        return false;
+    }
+
     psFree(output);
   }