摘要：1.TREE表:[strID] [int] IDENTITY(1,1) NOT NULL,[strName] [nvarchar](50) NOT NULL,2.SubInfoCREATE TABLE [dbo].[SubInfo]([SuBID] [int] NOT NULL,[SubTreeID] [nvarchar](max) NULL,SQL语句为:select a.strID,a.strName from Tree as a where exists(select * from SubInfo where charindex(cast(a.strID as varchar(max)) 阅读全文