select数据库表时，将数据进行求和统计sum( *)或者count(*)时一定要 与 group by同用：
例： select
a~MATNR
a~meins
a~BWART
a~mblnr
a~EBELN
sum( a~MENGE ) as menge
sum( a~DMBTR ) as dmbtr
into corresponding fields of table g_t_result1
from mseg as a inner join mkpf as b on a~mblnr = b~mblnr AND a~mjahr = b~mjahr
where a~LGORT in s_LGORT and
a~matnr in s_matnr and
b~budat in s_budat
group by a~MATNR "SUM 和GROUP在SELECT中一起使用
a~meins
a~BWART
a~mblnr
a~EBELN .
例： select
a~MATNR
a~meins
a~BWART
a~mblnr
a~EBELN
sum( a~MENGE ) as menge
sum( a~DMBTR ) as dmbtr
into corresponding fields of table g_t_result1
from mseg as a inner join mkpf as b on a~mblnr = b~mblnr AND a~mjahr = b~mjahr
where a~LGORT in s_LGORT and
a~matnr in s_matnr and
b~budat in s_budat
group by a~MATNR "SUM 和GROUP在SELECT中一起使用
a~meins
a~BWART
a~mblnr
a~EBELN .
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23537555/viewspace-662370/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
