select
a.HINCD as 商品CD
,a.KANRICD as 管理CD
,GI19TM_002.calcdy as 出荷日
,a.KIKISCD as 期层
,a.OLDSKADY as 元出荷日
,ISNULL(a.SKAKBN,0) as 出荷区分
,ISNULL(a.SKASRY,0) as 出荷当日数
from
(select HINCD as 商品CD
,KANRICD as 管理CD
,GI19TM_002.calcdy as 出荷日
,KIKISCD as 期层
,OLDSKADY as 元出荷日
,SKAKBN as 出荷区分
,sum(SKASRY) as 出荷当日数
from GI19TW_104 as a
where a.SKAKBN ='0'
group by a.HINCD,a.KANRICD,a.KIKISCD,GI19TM_002.calcdy,a.OLDSKADY,a.SKAKBN)right outer join GI19TM_002 on
a.SKADY=GI19TM_002.calcdy
where
GI19TM_002.KASHOCD='021'
and GI19TM_002.KASHOKBN='2'求大虾们帮着看看 这条语句到底哪错了
解决方案 »
- 数据表中增加一列,我是菜鸟,谢谢了!!!
- sql 导出数据到Excel 指定开始行 日期格式转换
- 请问如何把一个字符型的字段(日期时间)转换成日期时间型的字段?(在线给分)
- 查询结果排序 混乱
- 求助 存储过程,怎样传递带"'"字符型参数
- 我不相信你会这个问题?
- 求能实现类似SUM功能(但字段是字符型,即将字符串连接起来)的SQL语句
- 找DOWN:VB 和 SQL Server 编程指南(第五版)与《VISUAL BASIC6。0数据库程序设计》
- 各位大侠,求救啊!!!!!!!!!!!!!!!!!!!!!!!!!!
- 一个困饶我很久的问题,怎样使几个数据库保持自动同步?(解决问题200分相送)
- SQLSERVER2005不让客户看到我的数据,怎么弄??
- 查询 sql 语句问题
(select HINCD as 商品CD
,KANRICD as 管理CD
,GI19TM_002.calcdy as 出荷日
,KIKISCD as 期层
,OLDSKADY as 元出荷日
,SKAKBN as 出荷区分
,sum(SKASRY) as 出荷当日数
from GI19TW_104 as a
where a.SKAKBN ='0'
group by a.HINCD,a.KANRICD,a.KIKISCD,GI19TM_002.calcdy,a.OLDSKADY,a.SKAKBN)aright outer join GI19TM_002 on
a.HINCD as 商品CD
,a.KANRICD as 管理CD
,GI19TM_002.calcdy as 出荷日
,a.KIKISCD as 期层
,a.OLDSKADY as 元出荷日
,ISNULL(a.SKAKBN,0) as 出荷区分
,ISNULL(a.SKASRY,0) as 出荷当日数
from
(select HINCD as 商品CD
,KANRICD as 管理CD
,GI19TM_002.calcdy as 出荷日
,KIKISCD as 期层
,OLDSKADY as 元出荷日
,SKAKBN as 出荷区分
,sum(SKASRY) as 出荷当日数
from GI19TW_104 as a
where a.SKAKBN ='0'
group by a.HINCD,a.KANRICD,a.KIKISCD,GI19TM_002.calcdy,a.OLDSKADY,a.SKAKBN)t--别名right outer join GI19TM_002 on
a.SKADY=GI19TM_002.calcdy
where
GI19TM_002.KASHOCD='021'
and GI19TM_002.KASHOKBN='2'
select
a.HINCD as 商品CD
,a.KANRICD as 管理CD
--,GI19TM_002.calcdy as 出荷日
,a.KIKISCD as 期階層
,a.OLDSKADY as 元出荷日
,ISNULL(a.SKAKBN,0) as 出荷区分
,ISNULL(a.SKASRY,0) as 出荷当日数
from
(select HINCD as 商品CD
,KANRICD as 管理CD
--,GI19TM_002.calcdy as 出荷日
,KIKISCD as 期階層
,OLDSKADY as 元出荷日
,SKAKBN as 出荷区分
,sum(SKASRY) as 出荷当日数
from GI19TW_104 where a.SKAKBN ='0'
group by a.HINCD,a.KANRICD,a.KIKISCD--,GI19TM_002.calcdy
,a.OLDSKADY,a.SKAKBN) as a
right outer join GI19TM_002 on
--
a.SKADY=GI19TM_002.calcdy
where
GI19TM_002.KASHOCD='021'
and GI19TM_002.KASHOKBN='2'
可还是出错 a.HINCD 这不能识别
这么写就没错 为什么阿
select
a.商品CD
,a.管理CD
--,GI19TM_002.calcdy as 出荷日
,a.期階層
,a.元出荷日
,ISNULL(a.出荷区分,0) as 出荷区分
,ISNULL(a.出荷当日数,0) as 出荷当日数
from
(select HINCD as 商品CD
,KANRICD as 管理CD
,KIKISCD-- as 期階層
,OLDSKADY as 元出荷日
,SKAKBN as 出荷区分
,sum(SKASRY) as 出荷当日数
,SKADY
from GI19TW_104 where SKAKBN ='0'
group by HINCD,KANRICD,KIKISCD--,OLDSKADY,SKAKBN) as a
right outer join GI19TM_002 on
--
a.SKADY=GI19TM_002.calcdy
where
GI19TM_002.KASHOCD='021'
and GI19TM_002.KASHOKBN='2'
a.HINCD
,a.KANRICD
,GI19TM_002.calcdy
,a.KIKISCD
,a.OLDSKADY
,ISNULL(a.SKAKBN,0)
,ISNULL(a.SKASRY,0)
from
(select HINCD
,KANRICD
,GI19TM_002.calcdy
,KIKISCD
,OLDSKADY
,SKAKBN
,sum(SKASRY)
from GI19TW_104 where a.SKAKBN ='0'
group by a.HINCD,a.KANRICD,a.KIKISCD,GI19TM_002.calcdy
,a.OLDSKADY,a.SKAKBN) as a
right outer join GI19TM_002 on
--
a.SKADY=GI19TM_002.calcdy
where
GI19TM_002.KASHOCD='021'
and GI19TM_002.KASHOKBN='2'可是 我这么写 还是不对啊。。
能不能帮我改写以下
*
from
(select HINCD as 商品CD
,KANRICD as 管理CD
,GI19TM_002.calcdy as 出荷日,KIKISCD as 期階層
,OLDSKADY as 元出荷日
,SKAKBN as 出荷区分
,sum(SKASRY) as 出荷当日数
from GI19TW_104 where SKAKBN ='0'
group by HINCD,KANRICD,KIKISCD,GI19TM_002.calcdy
,OLDSKADY,SKAKBN) as a
right outer join GI19TM_002 onSKADY=GI19TM_002.calcdy
where
GI19TM_002.KASHOCD='021'
and GI19TM_002.KASHOKBN='2'
我已经改成这个样子了。。就差一点就要实现了。。红色的两个地方出错。。不知道是什么原因
select
a.商品CD
,a.管理CD
,GI19TM_002.calcdy as 出荷日
,a.期階層
,a.元出荷日
,ISNULL(a.出荷区分,0) as 出荷区分
,ISNULL(a.出荷当日数,0) as 出荷当日数
from
(select HINCD as 商品CD
,KANRICD as 管理CD
,KIKISCD as 期階層
,OLDSKADY as 元出荷日
,SKAKBN as 出荷区分
,sum(SKASRY) as 出荷当日数
,SKADY
from GI19TW_104 where SKAKBN ='0'
group by HINCD,KANRICD,KIKISCD,OLDSKADY,SKAKBN,SKADY) as a
right outer join GI19TM_002 on
a.SKADY=GI19TM_002.calcdy
where
GI19TM_002.KASHOCD='021'
and GI19TM_002.KASHOKBN='2'试试行不行
2。 SKADY 无效
怎么修改好啊
a.HINCD
,a.KANRICD
,GI19TM_002.calcdy as 出荷日,a.KIKISCD
,a.OLDSKADY
,ISNULL(a.SKAKBN,0)
,ISNULL(a.SKASRY,0)
from
(select HINCD
,KANRICD
,GI19TM_002.calcdy as 出荷日
,KIKISCD
,OLDSKADY
,ISNULL(SKAKBN,0) as SKAKBN
,sum(ISNULL(SKASRY,0)) as SKASRY
from GI19TW_104 where SKAKBN ='0'
group by HINCD,KANRICD,KIKISCD--,GI19TM_002.calcdy
,OLDSKADY,SKAKBN) as a
right outer join GI19TM_002 on
SKADY=GI19TM_002.calcdy
where
GI19TM_002.KASHOCD='021'
and GI19TM_002.KASHOKBN='2'还是红色的部分出错
t.HINCD
,t.KANRICD
,t.SKADY as 出荷日1
,GI19TM_002.calcdy as 出荷日,t.KIKISCD
,t.OLDSKADY
,ISNULL(t.SKAKBN,0)
,ISNULL(t.SKASRY,0)
from
(select HINCD
,KANRICD
,SKADY
,GI19TM_002.calcdy as 出荷日,KIKISCD
,OLDSKADY
,ISNULL(SKAKBN,0) as SKAKBN
,sum(ISNULL(SKASRY,0)) as SKASRY
from GI19TW_104 where SKAKBN ='0'
group by HINCD,KANRICD,KIKISCD,GI19TM_002.calcdy,SKADY,OLDSKADY,SKAKBN) as t
right outer join GI19TM_002 on
t.SKADY=GI19TM_002.calcdy
where
GI19TM_002.KASHOCD='021'
and GI19TM_002.KASHOKBN='2'感谢AcHerat
还剩下最后一个问题了 就是那个又连接的问题。。编译不过去 总说红色的部分不识别。。是怎么回事啊
我试试阿
a.HINCD
,a.KANRICD
,b.calcdy
,a.KIKISCD
,a.OLDSKADY
,ISNULL(a.SKAKBN,0)
,ISNULL(a.SKASRY,0)
from
(select HINCD,KANRICD,KIKISCD,OLDSKADY,SKAKBN,sum(SKASRY) SKASRY
from GI19TW_104
where SKAKBN ='0'
group by HINCD,KANRICD,KIKISCD,OLDSKADY,SKAKBN) as a
right outer join GI19TM_002 b on
a.OLDSKADY=b.calcdy
where b.KASHOCD='021' and b.KASHOKBN='2'