WITH CONVENIENCE2 AS
  (
    SELECT
      SURVEY_YEAR,
      PF_CODE,
      TOTAL_VALUE
    FROM
      CONVENIENCE
    WHERE
      TOTAL_VALUE IS NOT NULL
    AND
      KIND_CODE = 100
    AND
      SURVEY_YEAR = 2018
  ),
  
con AS
  (
    SELECT
      *
    FROM
      CONVENI_SALE_2018
      
    UNION ALL
    
    SELECT
      *
    FROM
      CONVENIENCE2
  )

SELECT
  *
FROM
  con