Post reply

Update Table using field from another table

  • July 22, 2003 at 3:18 pm

    #83935

    Can someone show me how to update a table with a field from another table. I have a field to match.

    Pseudocode:

    Update the id field on TableA with the id field from TableB.

    Join the tables using xCode on both tables.

    Only update records on TableA when the id is blank.

    Thanks in advance for your time.

  • July 22, 2003 at 3:52 pm

    #466489 

     UPDATE TableA

    SET id = TableB.id

    FROM TableA 

    INNER JOIN TableB ON TableA.xCode = TableB.xCode

    WHERE TableA.id IS NULL OR TableA.id = ''


    Cheers,
    - Mark

  • July 28, 2003 at 3:59 pm

    #467373

    Thank You

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply