Thanks heaps.

That's exactly what I've been looking for.

Here's what I went with:

insert into tbl_NoProfile ([FileName], SourceZIP, FilePath, PKZIPID)

select JustTheName, SourceZIPFile, [FileName], [ID]

from tbl_PKZIPAnalysis

WHERE NOT EXISTS

   (SELECT [ID]

   FROM tbl_Profiles

   WHERE tbl_PKZIPAnalysis.JustTheName = tbl_Profiles.[FileName])

(77503 row(s) affected) - 58...

Thanks for your suggestion.

However, I have a 800K row table and a 680K row table, and I'm working with an under-specced mssql2k server.  It takes ~10 secs just to do...