declare @t1 table ( nameid int primary key, name nvarchar(20), typename nvarchar(20), money int, zhunameid int)insert into @t1 values(123,'新','主合同',1000,null)insert into @t1 values(234,'新附属1','补充合同',200,123)insert into @t1 values(345,'新附属2','补充合同',100,123)insert into @t1 values(1,'new','new主合同',100,null)ins...
|