关于记录删除语句的写法，回答有分呀
我想删除info_P_Char中的记录，但是WHERE后的一个条件无法过滤，所以关联了另外一个表限制，不过不能执行，请教，是不是DELETE后不能用表的关联呀
SQL=delete *
FROM Info_P_Char INNER JOIN
Info_Equipment ON Info_P_Char.D_ID = Info_Equipment.D_ID
WHERE (Info_P_Char.P_NAME = 'YYY') AND (Info_Equipment.E_ID = '3')
问题点数：50、回复次数：3Top
1 楼pengdali（）回复于 2003-11-04 15:03:13 得分 25
delete Info_P_Char where P_NAME = 'YYY' and D_ID in (select D_ID from Info_Equipment where E_ID = '3')Top
2 楼sdhdy（大江东去...）回复于 2003-11-04 15:03:39 得分 25
delete Info_P_Char from Info_Equipment
WHERE (Info_P_Char.P_NAME = 'YYY') AND (Info_Equipment.E_ID = '3') and Info_P_Char.D_ID = Info_Equipment.D_IDTop
3 楼kimurakenshin（浪客）回复于 2003-11-04 16:16:36 得分 0
upTop
