基于联表模糊查询的SQL

测试表b

if exists (select * from sysobjects where id = OBJECT_ID('[b]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [b]
CREATE TABLE [b] ( [b1] [varchar] (50) NULL , [b2] [varchar] (50) NULL )。

INSERT [b] ( [b1] , [b2] ) VALUES ( '1' , '112' )
INSERT [b] ( [b1] , [b2] ) VALUES ( '2' , '11' )

测试表a

ssss	ss
ss	sss

if exists (select * from sysobjects where id = OBJECT_ID('[a]') and OBJECTPROPERTY(id, 'IsUserTable') = 1) DROP TABLE [a]
CREATE TABLE [a] ( [a1] [varchar] (50) NOT NULL , [a2] [varchar] (50) NOT NULL )

INSERT [a] ( [a1] , [a2] ) VALUES ( '1' , '11' )
INSERT [a] ( [a1] , [a2] ) VALUES ( '2' , '1122' )
INSERT [a] ( [a1] , [a2] ) VALUES ( '3' , '1122' )
INSERT [a] ( [a1] , [a2] ) VALUES ( '4' , '112' )
INSERT [a] ( [a1] , [a2] ) VALUES ( '5' , '111' )

要写sql解决的问题是：

求b表中的字段b2,在a表中的字段a2中模糊匹配的个数．注意：需要最长匹配！也就是a表中的a2字段1122,统计时只能放在112中，而不能算做11的统计个数：或选取的数据如下：

11,11

11,111

112,1122

112,1122

112,112

也即：

11：共两条，112共三条