DELETING items

[rob anderson]

I am trying to delete records from a table, where the 'id' to be deleted should only 
happen if a certain flag (status) exists.

The table contains one or more records for the same id, only the flag changes.

I have tried 


create temporary table temp (id int not null);

select id from tracking where tracking.status = 5;

delete from tracking
    where id = select temp.id from temp;

drop table temp;



But this fails.




I am not a SQL guru, and would appreciate any help


Rob