SQL语句如下：
select t1.sf_commercial_team,
t1.asg_greater_region_name,
t1.asg_region_eng_name,
t1.asg_division_name,
t1.asg_area_eng_name,
t1.asg_city_eng_name,
t1.sf_new_image,
t1.ol_channel_grade,
t1.sf_channel_group_eng_name,
t1.sf_channel_eng_name,
t1.sa_crmno,
t1.org_eng_name,
t1.org_name,
t1.ka_account,
t1.ol_parent_crmno,
t1.ol_parent_eng_name,
t1.ol_parent_name,
t1.ol_sales_rep_eng_first_name,
t3.category_eng_name,
t3.brand_eng_name,
t3.subbrand_code,
t3.subbrand_eng_name,
t3.item_group_attr_03 as item_group_code,
t3.item_group_attr_02 as item_group_des,
t3.skucode,
t3.sku_eng_name,
t3.physical_bottle_size,
t3.packaging_size,
t4.incurred_period,
sum(t4.quantity_9l) as Offtake
from crmv_party t1, crmv_sku t3, crmv_outlet_offtake t4
where t1.sa_salers = t4.sold_to
and t3.sku = t4.inputsku
and t4.incurred_period >= 201601
and t4.quantity_9l <> 0
group by t1.sf_commercial_team,
t1.sf_commercial_team,
t1.asg_greater_region_name,
t1.asg_region_eng_name,
t1.asg_division_name,
t1.asg_area_eng_name,
t1.asg_city_eng_name,
t1.sf_new_image,
t1.ol_channel_grade,
t1.sf_channel_group_eng_name,
t1.sf_channel_eng_name,
t1.sa_crmno,
t1.org_eng_name,
t1.org_name,
t1.ka_account,
t1.ol_parent_crmno,
t1.ol_parent_eng_name,
t1.ol_parent_name,
t1.ol_sales_rep_eng_first_name,
t3.category_eng_name,
t3.brand_eng_name,
t3.subbrand_code,
t3.subbrand_eng_name,
t3.item_group_attr_03,
t3.item_group_attr_02,
t3.skucode,
t3.sku_eng_name,
t3.physical_bottle_size,
t3.packaging_size,
t4.incurred_period

想在这段sql里面添加 t4表的GL_DATE,怎么添加？

是啊，就是这么简单，我不知道为什么我之前这样加进去为运行不成功。

有大佬回答吗