I've turned to creating a temp table and putting the primary keys from the select statement into there so I can guard myself against the thing that was to delet

I've turned to creating a temp table and putting the primary keys from the select statement into there so I can guard myself against the thing that was to delete a handful of rows deleting everything. Plus with that you can do another join and see if those rows have some sort of value in it that you didn't expect.