How do I delete only if multiple conditions met (SQL server)

See more:

SQL

Microsoft

Hello-

I have two temp tables. The first table called ##temp_first has all the id numbers I need to provide for a report. I want to excluded certain id numbers if a certain criteria is met. The problem I am having is its deleting id numbers that I need to keep. For example, I need to delete id numbers if they have a reply entry as 'BACK' but not if the id number also has a 'DONE' associated with it. In the example below, I need to delete id numbers = 3285647550 but NOT delete id number = 3285653374. 3285653374 has both a 'DONE' and 'BACK' associated with it but since it has a BACK associated with it, I'd like to ignore that one.

-- starts with these --

id reply
3285647550 UP
3285647550 BACK

3285653374 UP
3285653374 UP
3285653374 UP
3285653374 DONE
3285653374 BACK

3286680422 DONE
3286688357 DONE
3286688452 DONE
3286696637 DONE


-- need only these --

id reply
3285653374 UP
3285653374 UP
3285653374 UP
3285653374 DONE
3285653374 BACK

3286680422 DONE
3286688357 DONE
3286688452 DONE
3286696637 DONE

What I have tried:

This is what I tried.

DELETE FROM ##temp_final
WHERE id IN (SELECT id FROM ##temp_first WHERE reply IN 'BACK')

DELETE FROM ##temp_final
WHERE id IN (SELECT id FROM ##temp_first WHERE (reply IN 'BACK' AND reply NOT IN 'DONE'))

I've tried a few other combinations but I still can't get my desired outcome.