这个语句怎么写，错在哪里？

[kindtoadsd]

delete from wxq c where exists (select b.* from t_wxq_lastmonthdata_old b
where c.intyear=b.intyear and c.intmonth=b.intmonth and c.itemnum=b.itemnum and c.deptnum=b.deptnum)

谢谢！

[xuyiquan1981]

b.* ?

[kindtoadsd]

消息 102，级别 15，状态 1，第 1 行
'c' 附近有语法错误。
多字段比较删除我一直不会写

[kindtoadsd]

很多我遇到过这个问题吧，你们是怎么解决的？

[合肥小菜]

delete from wxq  where exists (select b.* from t_wxq_lastmonthdata_old b  
where wxq.intyear=b.intyear and wxq.intmonth=b.intmonth and wxq.itemnum=b.itemnum and wxq.deptnum=b.deptnum)

[kindtoadsd]

对了，谢谢你！

[bashen1101]

delete from wxq,t_wxq_lastmonthdata_old b  
where wxq.intyear=b.intyear and wxq.intmonth=b.intmonth and wxq.itemnum=b.itemnum and wxq.deptnum=b.deptnum