SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT 1  
GroupId ,      'Inactive' GroupName  ,1 PersonId
INTO tab
UNION ALL SELECT 2 ,       'Inactive',  2
UNION ALL SELECT 3,        'Inactive',  3
3 rows affected

SELECT * FROM tab


GroupId
GroupName
PersonId


1
Inactive
1

2
Inactive
2

3
Inactive
3


SELECT t1.GroupId, t2.GroupName, t3.PersonId FROM tab t1, tab t2, tab t3
EXCEPT
SELECT GroupId, GroupName, PersonId FROM tab;


GroupId
GroupName
PersonId


1
Inactive
2

1
Inactive
3

2
Inactive
1

2
Inactive
3

3
Inactive
1

3
Inactive
2

GroupId	GroupName	PersonId
1	Inactive	2
1	Inactive	3
2	Inactive	1
2	Inactive	3
3	Inactive	1
3	Inactive	2