Home Forums SQL Server 7,2000 T-SQL Update Table using field from another table RE: Update Table using field from another table

  • 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