insert into CONVENIENCE(SURVEY_YEAR,PF_CODE,TOTAL_VALUE)
select
    c.SURVEY_YEAR,c.PF_CODE,c.TOTAL_VALUE
from
    CONVENIENCE as c
join
    CONVENI_SALE_2018 as cs on c.SURVEY_YEAR = cs.SURVEY_YEAR and c.PF_CODE = cs.PF_CODE
where
    c.SURVEY_YEAR = 2018
and
    c.KIND_CODE = "100"
and
    c.TOTAL_VALUE is not null