UPDATE 
    CONVENI_SALE_2018
SET
    SURVEY_YEAR = C.SURVEY_YEAR
    ,PF_CODE = C.PF_CODE
    ,TOTAL_VALUE = C.TOTAL_VALUE
    
FROM
    CONVENIENCE AS C
    WHERE
    C.SURVEY_YEAR = '2018'
    AND
    C.KIND_CODE = '100'
    AND
    C.TOTAL_VALUE IS NOT NULL;