34,587
社区成员
发帖
与我相关
我的任务
分享求SQL语句，在线等！
以下SQL如何实现，谢谢！！！
select a.1
a.2
b.3,
sum(a.4),
a.5,
a.6
from pcReclaimM a
group by a.1,a.2
left join PCCustView b on b.1=a.1
select a.1
a.2
b.3,
sum(a.4),
a.5,
a.6
from pcReclaimM a
group by a.1,a.2
left join PCCustView b on b.1=a.1
...全文
请发表友善的回复…
发表回复
jiangchuandong 2003-10-02
- 打赏
- 举报
是表的自连接
teaism 2003-10-02
- 打赏
- 举报
select a.1
a.2
b.3,
sum(a.4),
a.5,
a.6
from pcReclaimM a
--group by a.1,a.2
left join PCCustView b on b.1=a.1
group by a.1,a.2,b.3,a.5,a.6
a.2
b.3,
sum(a.4),
a.5,
a.6
from pcReclaimM a
--group by a.1,a.2
left join PCCustView b on b.1=a.1
group by a.1,a.2,b.3,a.5,a.6
colinmad 2003-10-02
- 打赏
- 举报
to txlicenhe(国庆只放一天假)
您的语句通过，非常感谢！！！能详细解释一下吗？
Join pcReclaimM c on aa.1 = c.1 and aa.2 = c.2 这一句不理解！！
顺便 ‘国庆只放一天假’真可怜！！
您的语句通过，非常感谢！！！能详细解释一下吗？
Join pcReclaimM c on aa.1 = c.1 and aa.2 = c.2 这一句不理解！！
顺便 ‘国庆只放一天假’真可怜！！
colinmad 2003-10-02
- 打赏
- 举报
在关键字 'left' 附近有语法错误。
teaism 2003-10-02
- 打赏
- 举报
错误信息呢？
colinmad 2003-10-02
- 打赏
- 举报
to teaism()
语法错误
语法错误
teaism 2003-10-02
- 打赏
- 举报
那就这样了。加个group by 就行了。
txlicenhe 2003-10-02
- 打赏
- 举报
楼主是只想按a.1,a.2两个字段分组吗？
select aa.1,aa.2,b.3,aa.4,c.5,c.6
from (Select a.1,a.2,sum(a.4) as 4 from pcReclaimM a group by a.1,a.2) aa
Join pcReclaimM c on aa.1 = c.1 and aa.2 = c.2
left join PCCustView b on b.1=c.1
select aa.1,aa.2,b.3,aa.4,c.5,c.6
from (Select a.1,a.2,sum(a.4) as 4 from pcReclaimM a group by a.1,a.2) aa
Join pcReclaimM c on aa.1 = c.1 and aa.2 = c.2
left join PCCustView b on b.1=c.1
colinmad 2003-10-02
- 打赏
- 举报
yes
teaism 2003-10-02
- 打赏
- 举报
是这意思吗？
select a.1
a.2
b.3,
sum(a.4),
a.5,
a.6
from pcReclaimM a
group by a.1,a.2
left join PCCustView b on b.1=a.1
group by a.1,a.2,b.3,a.5,a.6
select a.1
a.2
b.3,
sum(a.4),
a.5,
a.6
from pcReclaimM a
group by a.1,a.2
left join PCCustView b on b.1=a.1
group by a.1,a.2,b.3,a.5,a.6
