在条件下寻找主/子表数据库？

I have a 2 tables:

我有2个表:

DECLARE @MASTER TABLE (MAST_ID INT, 
                       MAST_NAME NVARCHAR(10), 
                       IS_ACTIVE CHAR(1)
                      )

INSERT INTO @MASTER 
VALUES (1, 'MAST1', 'A'), (2, 'MAST2', 'I'), 
       (3, 'MAST3', 'A'), (4, 'MAST4', 'A')

SELECT * FROM @MASTER

DECLARE @CHILD TABLE (CHD_ID INT, 
                      MAST_ID INT, 
                      CHD_NAME NVARCHAR(10), 
                      IS_ACTIVE CHAR(1)
                     )

INSERT INTO @CHILD 
VALUES (1, 1, 'CHD1', 'I'), (2, 2, 'CHD2', 'A'), 
       (3, 4, 'CHD3', 'A'), (4, 4, 'CHD4', 'I') 

SELECT * FROM @CHILD
DECLARE @MASTER T