Re: DELETE FROM A BLACK LIST

On Wed, Mar 05, 2003 at 11:27:54 +0100, luca.scaramella@recom.it wrote:
> Hi all,
> I have a Blacklist table containing about 1000 ID to delete from another
> table (T1 about 1440294 records)
> If i use the SQL
> 
> DELETE FROM T1 WHERE T1.ID IN (SELECT BLACKLIST.ID FROM BLACKLIST)

Use:

delete from t1 where t1.id = blacklist.id;