查找担保圈-step7-提取未被包含过组的成员，得出结论

USE [test]
GO
/****** Object:  StoredProcedure [dbo].[p05_get_group_member_cleared]    Script Date: 2019/7/8 15:32:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[p05_get_group_member_cleared]
AS
--s5，提取未被包含过组的成员，得出结论
BEGIN
    IF OBJECT_ID(N'dbo.t05_get_group_member_cleared') IS NOT NULL
        DROP TABLE dbo.t05_get_group_member_cleared;

    SELECT groupno AS 组编号,
           id AS 组内编号,
           cust_name,
           nlevel AS 成员数
    INTO dbo.t05_get_group_member_cleared
    FROM [dbo].t02_get_group_member AS a
    WHERE [groupno] IN (
                           SELECT iinclude_groupno FROM dbo.t04_get_groupno_cleared
                       );
END;