Ok, well what if you have 2 or more primary key restraints on that record you are trying to delete? How do you at the same time delete the other 2 records in the 2 tables with the restraints using the same delete statement?<BR><BR>I am using the following (in ASP):<BR><BR>dim RecordToDelete<BR>RecordToDelete=CInt(Request.Form ("ID"))<BR>dim cmd<BR>Set cmd=Server.CreateObject("ADODB.Command")<BR>cmd.Ac tiveConnection=oConn<BR>cmd.CommandText="DELETE FROM Table1,Table2,Table3 WHERE Table1.ID=" & RecordToDelete & " AND Table2.ID=" & RecordToDelete & " AND Table3.ID=" & RecordToDelete<BR>cmd.Execute<BR>rs.Requery &#039This was the recordset created earlier<BR><BR>So, I keep getting an Incorrect Syntax error Microsoft OLE DB Provider for SQL Server error &#039 80040e14&#039. What&#039s the problem with my sql statement?