Index: trunk/ippTools/share/pxadmin_drop_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_drop_tables.sql	(revision 23893)
+++ trunk/ippTools/share/pxadmin_drop_tables.sql	(revision 23894)
@@ -69,4 +69,8 @@
 DROP TABLE IF EXISTS rcDSFileset;
 DROP TABLE IF EXISTS rcRun;
+DROP TABLE IF EXISTS receiveSource;
+DROP TABLE IF EXISTS receiveFileset;
+DROP TABLE IF EXISTS receiveFile;
+DROP TABLE IF EXISTS receiveResult;
 
 SET FOREIGN_KEY_CHECKS=1
Index: trunk/ippTools/share/receivetool_pendingfile.sql
===================================================================
--- trunk/ippTools/share/receivetool_pendingfile.sql	(revision 23893)
+++ trunk/ippTools/share/receivetool_pendingfile.sql	(revision 23894)
@@ -1,6 +1,13 @@
-SELECT *
+SELECT
+    receiveFile.file_id,
+    source,
+    product,
+    workdir,
+    fileset,
+    file
 FROM receiveFile
 JOIN receiveFileset USING(fileset_id)
 JOIN receiveSource USING(source_id)
-LEFT JOIN receiveResult USING(file_id)
-WHERE receiveFile.file_id IS NULL
+LEFT JOIN receiveResult
+    ON receiveResult.file_id = receiveFile.file_id
+WHERE receiveResult.file_id IS NULL