不好意思,昨晚没上网!多谢各位大佬的关注。 具体应该是这样的。 Create table Project(CaseID varchar(20),HouseArea int) Create table Company(CaseID varchar(20),RegisteTypeBM varchar(20),AptitudeBM varchar(20))Insert into Project(CaseID,HouseArea) values('01',11) Insert into Project(CaseID,HouseArea) values('02',22)Insert into Company(CaseID,RegisteTypeBM,AptitudeBM) values('01','R1','A1') Insert into Company(CaseID,RegisteTypeBM,AptitudeBM) values('02','R2','A1') Select Sum(A.HouseArea) From Project as A inner join Company as B on A.CaseID = B.CaseID group by B.RegisteTypeBM UnionSelect Sum(A.HouseArea) From Project as A inner join Company as B on A.CaseID = B.CaseID group by B.AptitudeBM
具体应该是这样的。
Create table Project(CaseID varchar(20),HouseArea int)
Create table Company(CaseID varchar(20),RegisteTypeBM varchar(20),AptitudeBM varchar(20))Insert into Project(CaseID,HouseArea) values('01',11)
Insert into Project(CaseID,HouseArea) values('02',22)Insert into Company(CaseID,RegisteTypeBM,AptitudeBM) values('01','R1','A1')
Insert into Company(CaseID,RegisteTypeBM,AptitudeBM) values('02','R2','A1')
Select Sum(A.HouseArea) From Project as A
inner join Company as B
on A.CaseID = B.CaseID
group by B.RegisteTypeBM
UnionSelect Sum(A.HouseArea) From Project as A
inner join Company as B
on A.CaseID = B.CaseID
group by B.AptitudeBM
有点大。所以我想如果只对Project和Company表查询一次,就能得出结果,那就太爽啦!