是这意思吗?
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
解决方案 »
- SQL Server 2000 SP4补丁有针对Enterprise Edition的还是各种版本都是通用的?
- 非常奇怪的问题:往SQL Server 2000导数据时,突然就连不上了
- 怎么删除SQL中一列的右边空格
- alter如何更改identity列?
- 远程MSSQL 报错,error:26-定位指定的服务器/实例时出错
- 如何只对SQLSERVER中表中的各别几列授权?
- ado配参数的问题
- Store procedure Question`
- 谁熟悉医疗保险软件开发?(500分)
- 超难!检测存储过程是否成功执行的问题!
- sqlserver里是否有自动增加字段类型,如何苗速,又如何对该纪录进行insert?
- sqlserver日志问题?
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
语法错误
您的语句通过,非常感谢!!!能详细解释一下吗?
Join pcReclaimM c on aa.1 = c.1 and aa.2 = c.2 这一句不理解!!
顺便 ‘国庆只放一天假’真可怜!!
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