Results 1 to 4 of 4

Thread: Subquery Error

  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Red face Subquery Error

    I am receiving the following error when trying to run this update query:

    Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

    UPDATE tbl_I_Engagements
    SET IsMaster = 0,
    MasterID = 1604
    WHERE MasterID = 87426

    It is a simple update with NO subquery and I don't understand why I'm getting the error. There is multiple records with MasterID = 87426 but I should be able to update multiple records at a time! I feel stupid posting this because it is probably some easy fix but I've been looking at it for too long!

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Maybe you should pick a platform appropriate forum..

    What platform is it?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    An d just as an shot from the hip, I'd say MasterId is not unique
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Mar 2004
    Posts
    2
    I figured it out! It was a trigger that was attached to the table.

Posting Permissions

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