Select IDs that doesn't exist

PHP
1

I have two tables: data and images

So, some IDs from table data were deleted in the meantime but I didn’t delete these IDs from the table images.

So, now I want to get all IDs that don’t exist in table data and delete these IDs in the table images.

Any idea?

Thanks.

2 

select id from images where id not in (select id from data)

if this returns the correct id’s then change the query from a select to a ‘delete from’

3

Thanks.