卡慕(提问者)SELECT sfec005 料号,imaal003 品名,imaal004 规格,sfec012 库位,sfec009 数量,imaa003 主分群,imaa009 产品分类码,sfea001 过账日期
FROM sfec_t
Left Join imaal_t ON imaal001 = sfec005
Left Join imaa_t ON imaa001 = sfec005
Left Join sfea_t ON sfeadocno = sfecdocno
Where sfea001 = to_date(\'${start}\' ,\'yyyy\')
where year(sfea001) = 2019
group by month(sfea001)
================
这样写貌似不对
firegunzx 回复 卡慕(提问者)SELECT sfec005 料号,imaal003 品名,imaal004 规格,sfec012 库位,sfec009 数量,imaa003 主分群,imaa009 产品分类码,sfea001 过账日期
FROM sfec_t Left Join imaal_t ON imaal001 = sfec005 Left Join imaa_t ON imaa001 = sfec005 Left Join sfea_t ON sfeadocno = sfecdocno
where year(sfea001) = 2019 group by month(sfea001)
1min目标场景问卷
立即参与
