Index: trunk/ippTools/share/receivetool_pendingfile.sql
===================================================================
--- trunk/ippTools/share/receivetool_pendingfile.sql	(revision 23885)
+++ 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