62,046
社区成员
发帖
与我相关
我的任务
分享
select t1.*,t2.HNameA,t3.TNum,t4.RNum,t5.r_ID,t5.r_uName,t5.r_date,t5.r_t_ID from tb_module t1
left join (select 回复时间,h_bk_ID,hName as HNameA from tb_Host group by h_bk_ID)t2 on t1.bk_ID = t2.h_bk_ID
left join (select 回复时间,t_bk_ID,count(t_ID) as TNum from t_Card group by t_bk_ID)t3 on t1.bk_ID = t3.t_bk_ID
left join (select 回复时间,r_bk_ID,count(r_ID) as RNum from r_Card group by r_bk_ID)t4 on t1.bk_ID = t4.r_bk_ID
left join (select 回复时间,r_bk_ID,r_uName,r_ID,r_date,r_t_ID from r_Card group by r_bk_ID)t5 on t1.bk_ID = t5.r_bk_ID
order by t1.回复时间 desc
;
select t1.*,t2.HNameA,t3.TNum,t4.RNum,t5.r_ID,t5.r_uName,t5.r_date,t5.r_t_ID from tb_module t1
left join (select h_bk_ID,hName as HNameA from tb_Host group by h_bk_ID)t2 on t1.bk_ID = t2.h_bk_ID
left join (select t_bk_ID,count(t_ID) as TNum from t_Card group by t_bk_ID)t3 on t1.bk_ID = t3.t_bk_ID
left join (select r_bk_ID,count(r_ID) as RNum from r_Card group by r_bk_ID)t4 on t1.bk_ID = t4.r_bk_ID
left join (select r_bk_ID,r_uName,r_ID,r_date,r_t_ID from r_Card group by r_bk_ID)t5 on t1.bk_ID = t5.r_bk_ID
;