select (select [Name] as typeName from tm_types where id=t.typeid) as typeName, O.[Name] as officeName,count(T.typeid) as Num from tm_Tools T,tm_offices O where T.officeid=O.id and T.typeid = @typeid and T.officeid=@officeid group by T.TYPEID,O.[Name]如何修改成模糊查询呢?谢谢。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货