日期:2014-05-18  浏览次数:20915 次

sql出错---说 right 附近有错误

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 code
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)t--别名

right outer join GI19TM_002 on
a.SKADY=GI19TM_002.calcdy  
where  
GI19TM_002.KASHOCD='021'
and GI19TM_002.KASHOKBN='2'

------解决方案--------------------
SQL code

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'

试试行不行

------解决方案--------------------
SKADY哪来的,不是OLDSKADY么?