Question

sql统计查询 多个子语句输出一个结果

select count(*) as Counts from TABLE.A inner join TABLE.Y on TABLE.A.AID = TABLE.Y.YID
select count(*) as Counts from TABLE.B inner join TABLE.Y on TABLE.A.BID = TABLE.Y.YID
select count(*) as Counts from TABLE.C inner join TABLE.Y on TABLE.A.CID = TABLE.Y.YID
这三句怎么合成一个?

Answer 1

把查询结果当成表
select a.Counts,b.Counts,c.Counts,a.Counts+b.Counts+c.Counts from

(select count(*) as Counts from TABLE.A inner join TABLE.Y on TABLE.A.AID = TABLE.Y.YID) a,

(select count(*) as Counts from TABLE.B inner join TABLE.Y on TABLE.A.BID = TABLE.Y.YID) b,

(select count(*) as Counts from TABLE.C inner join TABLE.Y on TABLE.A.CID = TABLE.Y.YID) c