DELETE TB1.*,TB2.* FROM TB1 INNER JOIN TB2 ON TB1.PersonID = TB2.PersonID WHERE (TB1.PersonID)='2'
它在MS Access中正常工作,但在sql Server Express 2005中收到错误(‘,’附近的错误语法).
如何解决？请帮忙.
获得此效果的最佳方法是在表与ON DELETE触发器之间指定FOREIGN KEYS.
