Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Location
    OH
    Posts
    10

    Angry Unanswered: Problem with the Update Query

    I would like to update a set of records that satisfy a particular condition as follows -->
    -----------------------------------

    Update TABLE_NAME
    Set FIELD_NAME = 'Value'
    Where <condition>

    ------------------------------------
    Then I get the following error :-

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

    ----------------------
    I guess we can perform an UPDATE transaction on multiple records based on a condition, can't we?

    Thanks in advance,
    ./darbhas

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621

    Re: Problem with the Update Query

    I guess your <condition> includes subquery.

    Statement below will return error:

    from tableA
    where fieldA=(select fieldB from tableB)

    but this statemet will work fine:

    from tableA
    where fieldA in(select fieldB from tableB)

  3. #3
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: Problem with the Update Query

    It may also be the 'value', if the value is taken from another table. Please post your complete UPDATE statement.
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

Posting Permissions

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