Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Posts
    2

    Unanswered: Ingres equivalent?

    I've tried the following sql on Ingres but it comes up with an error...

    UPDATE size SET as=
    (SELECT feature_detail
    FROM details
    WHERE mod_uuid = '11E874E9-65B7-DB96-1CF52F59557C4631' AND feature_uuid = '62006489-65B7-DB96-1334DDB7ACD83765')
    WHERE mod_uuid='11E874E9-65B7-DB96-1CF52F59557C4631'

    What should I change to make this work on Ingres?

  2. #2
    Join Date
    Jul 2003
    Location
    England
    Posts
    152
    Is size the table you are updating, or the field you want to update?

    SQL format will be

    update <table>
    set <field> = ( select <field>
    from <table>
    where ... )

    Note the result of the inner select must be a single value.
    Regards
    Dbabren

Posting Permissions

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