点击此处---> 群内免费提供SAP练习系统(在群公告中)
加入QQ群:457200227(SAP S4 HANA技术交流) 群内免费提供SAP练习系统(在群公告中)
我有详尽的报告,但行不断重复我该怎么做..这是我的qwery
选择" mydb__Posted_Settlement"。"结算编号"," mydb__Posted_Settlement"。"供应商编号"," mydb__Posted_Settlement"。"到期日期"," mydb__Posted_Settlement"。"结算日期"," mydb__Posted_Settlement"。"名称 "。"城市"," mydb__Posted_Settlement_Line"。"项目编号"," mydb__Posted_Settlement_Line"。"描述"," mydb__Posted_Settlement_Line"。"肉类百分比"," mydb__Posted_Settlement_Line"。"结算重量"," mydb__Posted_Set"。 " mydb__Posted_Settlement_Line"。"金额"," mydb__Posted_Settlement_Line"。"数量"," mydb__Posted_Settlement_Line"。"结算率"," mydb__Posted_Settlement_Line"。"供应商标签"," mydb__Posted_Settlement_Add__Ded"," _"。 " mydb__Posted_Settlement_Add__Ded_"。"金额"来自(" FCL-DBS-01"。" dbo"。" mydb_ $ Posted结算"" mydb__Posted_Settlement"左外部联接" FCL-DBS-01"。" dbo"。" mydb_ $ Posted结算 行"" mydb__Posted_Settlement_Line"开" mydb__Posted_Se ttlement"。"结算编号"" =" mydb__Posted_Settlement_Line"。"结算编号")左外连接" FCL-DBS-01"。" dbo"。" mydb_ $ Posted Settlement Add__Ded_"" mydb__Posted_Settlement_Add__Ded_" ON" mydb__Posted_Settlement"。 " =" mydb__Posted_Settlement_Add__Ded_"。"结算编号"" ORDER BY" mydb__Posted_Settlement"。"结算编号"
由于联接增加了额外的行,因此您看到的是数据的多个副本-我认为,Posted_Settlement_Line的Post_Settlement中的每一行都可以有多行。 我不确定要加入的另一个表。
这是我要做的,以使报告更易读:
-Dell
一周热门 更多>