select   case 
	  when a1.APPROVED_PLAN -a2.APPROVED_PLAN=0  then	1
	  else 0  end  as test_result
  from 
     (SEL  SUM(APPROVE_PLAN)   APPROVED_PLAN, FRMT_ID
      FROM DEV_DB_HYP.V_SALES_PLAN_WA
      WHERE MONTH_ID  between 201810 and 201212
	GROUP BY FRMT_ID 
      ) A1 inner join
    (SEL SUM(APPROVE_PLAN) APPROVED_PLAN , FRMT_ID
    FROM DEV_DB_ODI.T_SALES_PLAN_WA_DAY_TMP PLAN
    INNER JOIN DEV_DB_HYP.V_DAYS D ON D.DAY_ID = PLAN.DAY_ID
    WHERE PLAN.MONTH_ID  between 201810 and 201812
    and APPROVE_PLAN is not null
	group by FRMT_ID)A2 on A1.FRMT_ID=A2.FRMT_ID