Delete Query

Results 1 to 2 of 2

Thread: Delete Query

  1. #1
    Join Date
    Dec 1969

    Default Delete Query

    Just wondering if it is possible to delete in an ASP page, my query is:<BR><BR>delete * FROM Person INNER JOIN Tax ON Person.ssn = Tax.ssn where ssn=1221<BR><BR>where Person has has Primart Key ssn, and tax has foreign key ssn.<BR><BR>Does anyone know what is wrong?<BR><BR>Thanks

  2. #2
    squeaky Guest

    Default RE: Delete Query

    Try two queries.<BR><BR>DELETE * FROM person WHERE SSN=1221<BR><BR>DELETE * FROM tax WHERE SSN=1221

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts