Excel Forum

Code: Select all

select location,group_no,group_name,a.item,item_desc,tran_code,gl_ref_no,month(tran_date)MM,sum(units) units,sum(total_cost) tt_cost
from DB_data..tran_data_R1_17 a,item_master b
where tran_date between '09-22-2017' and '03-21-2018'
and a.item=b.item 
and gl_ref_no in ('13') 
and location in ('691') 
and tran_code in ('22','23')
group by location,group_no,group_name,a.item,item_desc,tran_code,gl_ref_no,month(tran_date)
union
select location,group_no,group_name,a.item,item_desc,tran_code,gl_ref_no,month(tran_date)MM,sum(units) units,sum(total_cost) tt_cost
from DB_data..tran_data_R1_18 a,item_master b
where tran_date between '09-22-2017' and '03-21-2018'
and a.item=b.item 
and gl_ref_no in ('13') 
and location in ('691') 
and tran_code in ('22','23')
group by location,group_no,group_name,a.item,item_desc,tran_code,gl_ref_no,month(tran_date)

Code: Select all

select location,group_no,group_name,a.item,item_desc,tran_code,gl_ref_no,month(tran_date)MM,sum(units) units,sum(total_cost) tt_cost
from DB_data..tran_data_R1_17 a,item_master b
where tran_date between '09-22-2017' and '03-21-2018'
and a.item=b.item  
and location in ('691') 
and tran_code in ('2')
and a.item in('0000095506500','4893049000423','8850161161247')
group by location,group_no,group_name,a.item,item_desc,tran_code,gl_ref_no,month(tran_date)