56,677
社区成员
发帖
与我相关
我的任务
分享
create TEMPORARY table Temp(ChannelID int) engine=heap;
insert Temp select distinct ChannelID from GenderChannels where isfixed=0 ;
select ChannelID,count(*) as num from MemberChannels where ChannelID in(select ChannelID from Temp)
group by ChannelID;
drop TEMPORARY table Temp;