Delete sql rows where IDs do not have a match from another table

I'm trying to delete orphan entries in a mysql table. I have 2 tables like this: Table `files`: id | .... ----|------ 1 | .... 2 | .... 7 | .... 9 | .... table `blob`: fileid | .... -------|----- 1 | .... 2 | .... 3 | .... 4 | .... 4 | .... 4 | .... 9 | .... The `fileid` and `id` columns can be used to join the tables together. I want to delete all rows in table `blob` where `fileid` cannot be found in the table `files.id`. So using the example above that would delete rows: 3 & 4(s) in the `blob` table.