求一SQL语句？

[downkey]

A表中包含B表中的数据，求删除A表中B中的所有记录的SQL语句？
这是我写的通不过：
delete from basicdata_temp where hkcarnum=(select hkcarnum from temp_basicdata);
在MSSQL2000中的查询分析器中通不过？
谢了各位

[aiunong]

delete from basicdata_temp where hkcarnum in(select hkcarnum from temp_basicdata);

[noil0125]

delete from basicdata_temp
where hkcarnum in (select hkcarnum from temp_basicdata)