Update one table with another tables values

    UPDATE TBL1

    SET TBL1.COL = TBL2.COL2

    FROM TBL1 INNER JOIN TBL2

    ON TBL1.ID=TBL2.ID

    WHERE TBL2.COL >=1