select name,count(situcod) as sit1 from table t1,
(select max(situcod)as sit2 from table2) t2
where t1.sit1<>t2.sit2 and t1.name=t2.name
group by t1.name
(select max(situcod)as sit2 from table2) t2
where t1.sit1<>t2.sit2 and t1.name=t2.name
group by t1.name
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货