create volatile table ZZMD00, no fallback, no before journal, no after journal(
	WeekID	SMALLINT, 
	LocID	INTEGER, 
	WJXBFS1	FLOAT, 
	WJXBFS2	FLOAT)
primary index (WeekID, LocID) on commit preserve rows

;insert into ZZMD00 
select	a15.WeekID  WeekID,
	a11.LocID  LocID,
	CAST (sum(a11.ItemRev) AS FLOAT)  WJXBFS1,
	CAST (sum(a11.ItemRev) AS FLOAT)  WJXBFS2
from	SALES_HISTORY	a11
	join	ITEM	a12
	  on 	(a11.ItemID = a12.ItemID)
	join	SUBCLASS_V	a13
	  on 	(a12.SubClassID = a13.SubClassID)
	join	CLASS_V	a14
	  on 	(a13.ClassID = a14.ClassID)
	join	THE_DAY_V	a15
	  on 	(a11.DayDT = a15.DayDT)
	join	LOCATION	a16
	  on 	(a11.LocID = a16.LocID)
	join	DISTRICT_V	a17
	  on 	(a16.DistID = a17.DistID)
where	(a17.RegID =  133 
 and a14.DeptID =  12 
 and a15.WeekID in ( 26 ,  78 ))
group by	a15.WeekID,
	a11.LocID

create volatile table ZZMD01, no fallback, no before journal, no after journal(
	WeekID	SMALLINT, 
	LocID	INTEGER, 
	WJXBFS1	FLOAT)
primary index (WeekID, LocID) on commit preserve rows

;insert into ZZMD01 
select	a16.WeekID  WeekID,
	a11.LocID  LocID,
	sum(a11.ItemRev)  WJXBFS1
from	SALES_HISTORY	a11
	join	RELATE_LAST_V	a12
	  on 	(a11.DayDT = a12.LastYearDT)
	join	ITEM	a13
	  on 	(a11.ItemID = a13.ItemID)
	join	SUBCLASS_V	a14
	  on 	(a13.SubClassID = a14.SubClassID)
	join	CLASS_V	a15
	  on 	(a14.ClassID = a15.ClassID)
	join	THE_DAY_V	a16
	  on 	(a11.DayDT = a16.DayDT and 
	a12.DayDT = a16.DayDT)
	join	LOCATION	a17
	  on 	(a11.LocID = a17.LocID)
	join	DISTRICT_V	a18
	  on 	(a17.DistID = a18.DistID)
where	(a18.RegID =  133 
 and a15.DeptID =  12 
 and a16.WeekID in ( 26 ,  78 ))
group by	a16.WeekID,
	a11.LocID

select	distinct coalesce(pa1.WeekID, pa2.WeekID)  WeekID,
	a12.WeekDesc  WeekDesc,
	coalesce(pa1.LocID, pa2.LocID)  LocID,
	a11.LocDesc  LocDesc,
	pa1.WJXBFS1  WJXBFS1,
	ZEROIFNULL(((ZEROIFNULL(pa1.WJXBFS2) - ZEROIFNULL(pa2.WJXBFS1)) / NULLIFZERO(pa2.WJXBFS1)))  WJXBFS2
from	ZZMD00	pa1
	full outer join	ZZMD01	pa2
	  on 	(pa1.LocID = pa2.LocID and 
	pa1.WeekID = pa2.WeekID)
	join	LOCATION	a11
	  on 	(coalesce(pa1.LocID, pa2.LocID) = a11.LocID)
	join	THE_WEEK_V	a12
	  on 	(coalesce(pa1.WeekID, pa2.WeekID) = a12.WeekID)


drop table ZZMD00

drop table ZZMD01