--等价的sql
select (
select count(t.id) from fm_userphoto t,userinfo u where t.userid in (7,3667,3740) and datediff(mm,t.addtime,getdate())<4 and t.userid=u.id
)
+
(
select count(t.id) from musicok t,userinfo u where t.userid in(7,3667,3740) and datediff(mm,t.adddate,getdate())<4 and t.userid=u.id
)
select (
select count(t.id) from fm_userphoto t,userinfo u where t.userid in (7,3667,3740) and datediff(mm,t.addtime,getdate())<4 and t.userid=u.id
)
+
(
select count(t.id) from musicok t,userinfo u where t.userid in(7,3667,3740) and datediff(mm,t.adddate,getdate())<4 and t.userid=u.id
)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货