一条sql语句，求高手帮忙
0
所有回答(3)
0
这个不难实现
0
select officeid ,门诊1,门诊2,门诊3,officeName,
(select
( select count(*) as Bcount from Table2 B where B.id=A.officeId
group by B.id ) +
( select count(*) as Ccount from Table3 C
where C.id==A.officeId group by C.id)) as AllCount
from Table1 A
(select
( select count(*) as Bcount from Table2 B where B.id=A.officeId
group by B.id ) +
( select count(*) as Ccount from Table3 C
where C.id==A.officeId group by C.id)) as AllCount
from Table1 A
0
SELECT officeid , COUNT(*) AS total INTO #temp FROM ( SELECT offceid FROM table2 UNION ALL SELECT offceid FROM table3 ) a GROUP BY offceid SELECT officeid , ( CASE WHEN EXISTS ( SELECT total FROM #temp WHERE officeid = table1.officeid ) THEN ( SELECT total FROM #temp WHERE officeid = table1.officeid ) ELSE 0 END ) AS Total FROM table1 DROP TABLE #temp
