TSQL for searching items in a different list by groups

Question

I have 2 tables as follows:

| Table 1             | Table 2
| Column 1 | Column 2 | Column 1    
|----------|----------|---------
|c1        |v1        | v1
|c1        |v2        | v2
|c1        |v4        | v3
|c2        |v2        | v4
|c2        |v7        | v5
|c3        |v1        | v6
|c3        |v3        | v7
|c3        |v4        
|c3        |v6        

I would like to “break the union” of each group to get the following result

 | Column 1 | Column 2
 |----------|---------
 |c1        |v3       
 |c1        |v5       
 |c1        |v6
 |c1        |v7                 
 |c2        |v1       
 |c2        |v3      
 |c2        |v4       
 |c2        |v5      
 |c2        |v6           
 |c3        |v2     
 |c3        |v5       
 |c3        |v7       

Essentially, find each value in table 2 that does not match table 1 in its group, in this scenario there will be column 1.

My initial attempts to join the two tables do not seem to produce the results that I am after, for example:

SELECT * FROM 
Table1 T1
FULL OUTER JOIN Table2 T2 on t1.Column2 = t2.Column1
where t1.column1 is null

Answer 1

Alternatively, you can use EXCEPT:

SELECT DISTINCT t1.c1
               ,t2.c1
FROM @t1 t1
CROSS APPLY @t2 t2
EXCEPT
SELECT *
FROM @t1

Answer 2

This should do what you need to:

declare @t1 table(c1 nvarchar(5),c2 nvarchar(5));
declare @t2 table(c1 nvarchar(5));

insert into @t1 values ('c1','v1'),('c1','v2'),('c1','v4'),('c2','v2'),('c2','v7'),('c3','v1'),('c3','v3'),('c3','v4'),('c3','v6');

insert into @t2 values ('v1'),('v2'),('v3'),('v4'),('v5'),('v6'),('v7');

select ta.c1
        ,t2.c1 as c2
from @t2 t2
    cross apply (select distinct c1 from @t1) ta
    left join @t1 t1
        on(t2.c1 = t1.c2
            and ta.c1 = t1.c1
            )
where t1.c1 is null
order by ta.c1
        ,ta.c1;

Conclusion:

c1  c2
------
c1  v3
c1  v5
c1  v6
c1  v7
c2  v1
c2  v3
c2  v4
c2  v5
c2  v6
c3  v2
c3  v5
c3  v7

Answer 3

, , , :

select distinct t1.c1, t2.c1 
from @t1 t1 
cross join @t2 t2
left join @t1 t on t1.c1 = t.c1 and t2.c1 = t.c2
where t.c1 is null