Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2004

    Unanswered: UPDATE using SELECT?

    I have a table and I want to update the field of a record by referencing it to another record. How do I do it?

    I tried the following SQL and got the error:
    cannot INSERT object view REF or user-defined REF

    UPDATE people SET Mother =
    FROM People P
    WHERE P.Name = 'Mary')
    WHERE Name='John'
    Last edited by flashharry82; 04-20-04 at 13:05.

Posting Permissions

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