17,377
社区成员
发帖
与我相关
我的任务
分享oracle 表连接时 给表取别名
select * from operareaen o left join (select d.statdt,
d.operareaid ,
d.productid ,
d.statusid,
sum(d.amountid)*d.statusid as total
from dprosalstaten d
where d.businessid=2
and d.statdt=20110602
group by d.statdt,d.operareaid,d.productid,d.statusid) f f.operareaid =o.OPERAREAID_PK
此句执行时就会报 ORA-00905 missing keyword 并且错误指示在 f.operareaid 的f处
但是
select * from operareaen o left join (select d.statdt,
d.operareaid,
d.productid,
d.statusid,
d.amountid
from dprosalstaten d
where d.businessid = 2
) f on f.operareaid=o.OPERAREAID_PK 就没问题
大为高手帮忙解释一下 看第一个句子怎么改呀 谢谢了
d.operareaid ,
d.productid ,
d.statusid,
sum(d.amountid)*d.statusid as total
from dprosalstaten d
where d.businessid=2
and d.statdt=20110602
group by d.statdt,d.operareaid,d.productid,d.statusid) f f.operareaid =o.OPERAREAID_PK
此句执行时就会报 ORA-00905 missing keyword 并且错误指示在 f.operareaid 的f处
但是
select * from operareaen o left join (select d.statdt,
d.operareaid,
d.productid,
d.statusid,
d.amountid
from dprosalstaten d
where d.businessid = 2
) f on f.operareaid=o.OPERAREAID_PK 就没问题
大为高手帮忙解释一下 看第一个句子怎么改呀 谢谢了
...全文
请发表友善的回复…
发表回复
hzmshmily 2011-06-18
- 打赏
- 举报
谢谢了 郁闷了我 看了好几遍都没发现这么低级的错误 哎 一着急就容易忘事情
luoyoumou 2011-06-18
- 打赏
- 举报
select * from operareaen o left join (select d.statdt,
d.operareaid ,
d.productid ,
d.statusid,
sum(d.amountid)*d.statusid as total
from dprosalstaten d
where d.businessid=2
and d.statdt=20110602
group by d.statdt,d.operareaid,d.productid,d.statusid) f on f.operareaid =o.OPERAREAID_PK
d.operareaid ,
d.productid ,
d.statusid,
sum(d.amountid)*d.statusid as total
from dprosalstaten d
where d.businessid=2
and d.statdt=20110602
group by d.statdt,d.operareaid,d.productid,d.statusid) f on f.operareaid =o.OPERAREAID_PK
