select
    con.survey_year,
    consale.pf_code,
    con.total_value
from
    CONVENIENCE as con
inner join 
    CONVENI_SALE_2018 as consale on con.total_value = consale.total_value
where
    con.kind_code = 100
    and
    con.total_value IS NOT NULL
;