有两张表: 一张为活动表(tbl_Actity),一张为活动人数表(tbl_ActityPerson),每报名一个人在人数表里加一条数据,
现在要查出:活动表(tbl_Actity)里的信息加上这条活动一共有多少已审核的人(也就是IsCheck=1)报名,谢谢大大们!
create table tbl_Actity
(
ActityId int identity(1,1) primary key,
Title nvarchar(50)
)
create table tbl_ActityPerson
(
Id int identity(1,1) primary key,
ActityId int,
IsCheck int default 0
)
现在要查出:活动表(tbl_Actity)里的信息加上这条活动一共有多少已审核的人(也就是IsCheck=1)报名,谢谢大大们!
create table tbl_Actity
(
ActityId int identity(1,1) primary key,
Title nvarchar(50)
)
create table tbl_ActityPerson
(
Id int identity(1,1) primary key,
ActityId int,
IsCheck int default 0
)
inner join tbl_ActityPerson b on a.ActityId=b.ActityId and b.IsCheck=1
left join (select count(ActityId) as iCount,ActityId from tbl_ActityPerson group by ActityId) b on a.ActityId = b.ActityId
select a.ActityIdfrom, count(b.ActityId) c Actity a
left join tbl_ActityPerson b
on a.ActityId = b.ActityId
where b.IsCheck = 1
group by a.ActityIdfrom
left join (select count(ActityId) as iCount,ActityId from tbl_ActityPerson where IsCheck = 1 group by ActityId) b on a.ActityId = b.ActityId
from tbl_Actity a
left join tbl_ActityPerson b on a.ActityId=b.ActityId
where b.IsCheck=1
group by a.Title
inner join tbl_ActityPerson b on a.ActityId=b.ActityId and b.IsCheck=1
from tbl_Actity as a
left join
(select ActityId,Count(ActityId) as CheckNum
from tbl_ActityPerson
where IsCheck=1
group by ActityId) as b
on a.ActityId=b.ActityId
left join (select count(ActityId) as iCount,ActityId from tbl_ActityPerson where IsCheck = 1 group by ActityId) b on a.ActityId = b.ActityId
from tbl_Actity a
inner join tbl_ActityPerson c on a.ActityId=c.ActityId where a.IsCheck=1
left join tbl_ActityPerson b
on a.ActityId = b.ActityId
where b.IsCheck = 1
group by a.ActityIdfrom