sql报表生成问题咨询

最新推荐文章于 2025-08-12 22:09:30 发布

原创最新推荐文章于 2025-08-12 22:09:30 发布 · 509 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql

问题咨询专栏收录该内容

0 篇文章

订阅专栏

63. select a.imlitm,a.imdsc1,a.imSRP2,a.imUOM1,a.imITM,f.sdlitm ,f.sdlotn,f.sduorg,f.sdpid,f.sdvr01,f.sdupmj,
64. b.CanningDate,b.ModifyDate,b.litm as retlitm,b.mcu,c.umCONV,b.doco,b.dcto,b.kcoo,b.years,count(*)
65. from crpdta.f4101 a
66. join crpdta.RetBCBaseInfo b on trim(b.litm) =trim(a.imlitm)
67. join crpdta.f4211fack f on trim(f.sdlitm) =trim(b.litm)
68. join crpdta.f41002 c on trim(c.umitm) = trim(a.imitm)
69. where f.sdvr01='CK130000105' --and b.outbondno='CK130000105';
70. and c.umum=a.imuom1 and c.umrum='ML'
71. group by a.imlitm,a.imdsc1,a.imSRP2,a.imUOM1,a.imITM,f.sdlitm ,f.sdlotn,f.sduorg,f.sdpid,f.sdvr01,f.sdupmj,

72. b.CanningDate,b.ModifyDate,b.litm as retlitm,b.mcu,c.umCONV,b.doco,b.dcto,b.kcoo,b.years

这个Sql语句哪里错误了啊，提示 ORA-00933: SQL 命令未正确结束
00933. 00000 - "SQL command not properly ended"
*Cause:
*Action:
行 72 列 3 出错