Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004
    Posts
    78

    Unanswered: Can't delete a record from a Many to Many Relationship

    Please see the attached Many to Many Sample.
    It has only one query that lists all students that is not assigned to any class.

    I would like to delete that student from a query of from code. Not from the table.
    Is this possible??

    Thanks
    Joe
    Attached Files Attached Files

  2. #2
    Join Date
    Jun 2004
    Posts
    50
    DELETE *
    FROM [Students]
    WHERE [Students].StudentID =
    (SELECT StudentWithoutClass.Students.StudentID
    FROM StudentWithoutClass; ) ;
    Monk
    The person who confesses ignorance shows it once; the person who conceals it shows it many times.

Posting Permissions

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