create table #AA(x varchar(10),y varchar(10),z varchar(50)) insert #aa select 'A','xx','分类表' insert #aa select 'B','xx','物资基础表' insert #aa select 'C','xx','物资出货表' select A.x,A.z,B.rows as z_num from #AA A left join sysindexes B on B.indid<2 and A.z=B.name ------------------------------- A 分类表 2 B 物资基础表 5 C 物资出货表 2 (B.indid<2 and 只是提高性能)
SELECT A.*,B._num from A INNER JOIN B ON A.Z = B.Z
insert #aa select 'A','xx','分类表'
insert #aa select 'B','xx','物资基础表'
insert #aa select 'C','xx','物资出货表'
select A.x,A.z,B.rows as z_num from #AA A left join sysindexes B on B.indid<2 and A.z=B.name
-------------------------------
A 分类表 2
B 物资基础表 5
C 物资出货表 2
(B.indid<2 and 只是提高性能)