这样删除记录的SQL语句如何实现？？请进入

[xuallen]

有三个表tblPotential，tblVisit，tblInfo
都有RecordID字段，想删除同一RecordID值的三个表中所有记录。
这样写总提示错误，请指点。

strSQL2="Delete from tblInfo JOIN tblVisit on Record='" & request.form("chkDel" & i) & "' " & _
"JOIN tblPotential ON Record='" & request.form("chkDel" & i) & "'"

[shanhe]

方法：
1、三个delete语句，join只用于选择select

2、采用存储过程

3、采用触发器

4、定义表间约束，级联删除

[511214]

存储过程

[yangyanli]

建议写三个del语句，简单方便。

[p559]

sql_Delete="Delete from tblInfo where Record='" & request.form
sql_Delete=sql_Delete&" Delete from tblVisit where Record='" & request.form
sql_Delete=sql_Delete&" Delete from tblInfo where Record='" & request.form