--- trunk/lib/BackupPC/SearchLib.pm	2005/07/11 14:32:40	19
+++ trunk/lib/BackupPC/SearchLib.pm	2005/07/11 14:58:54	20
@@ -87,7 +87,7 @@
 		FROM files 
 			INNER JOIN shares	ON files.shareID=shares.ID
 			INNER JOIN hosts	ON hosts.ID = shares.hostID
-			INNER JOIN backups	ON backups.num = files.backupNum
+			INNER JOIN backups	ON backups.num = files.backupNum and backups.hostID = hosts.ID
 			LEFT  JOIN dvds		ON dvds.ID = files.dvdid
 	  };