Shove Tom's query into an IN clause - is this what you are after?

select distinct r.CompanyName, p.projectID, p.Title, p.datecreated

from tblResources r

join tblRecruiters rc on rc.ResourceID = r.ResourceID

join tblProfiles pr on...

Try replacing "tape" with "disk":

"restore database [master] from DISK = 'L:\master.bak' with replace"

At the moment, just to get it working, I've resorted to using a couple of cursors to populate temp tables, then joining the temp tables in the main query.  Obviously...

Thanks Steve

Matt