On Wed, Mar 05, 2003 at 11:27:54 +0100,
luca(dot)scaramella(at)recom(dot)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;