Delete from table where id is not in another tbl?

[Anon]

Can someone advise on the MySQL query for the following scenario:

I have a table full of files availble for download (tblFiles), I also have a junction table (jtbl_Downloads) that contains a users id (UserId) and files id (FileId). Each time a user downloads a file, it adds an entry to jtbl_Downloads. The problem is that I cleaned out tblFiles table, deleting many files. Now I have all of these download entries refering to files that no longer exist.

How can I construct a query that says,
DELETE FROM jtbl_Downloads WHERE FileId does not exist in tblFiles

Thanks!

[Anon]

Try the query below:

DELETE FROM jtbl_Downloads WHERE FileId not in (SELECT FileId FROM tblFiles);

Good luck,

Tom

[Anon]

the solution is in the form of a subquery (delete)
Does mySQL support subquery ?? i doubt...

instead u've to loop thro..all the files in "junction" table compare each file to the "master file" table - if it exists move to next else delete that "junction file"

u've to do it programaticaly i beleive.