SQL Server 2022

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

create table requirements (
    intraworkno int
);
insert into requirements (intraworkno) values
(10),
(20),
(30);
3 rows affected

create table results (
    sequence int,
    intraworkno int,
    part int
);
insert into results (sequence, intraworkno, part) values
(1, 10, 0),
(1, 30, 0),
(2, 10, 0),
(2, 20, 0),
(2, 30, 0),
(3, 10, 0),
(3, 10, 1),
(3, 10, 2),
(6, 40, 0),
(7, 40, 0),
(8, 10, 0),
(8, 20, 0),
(8, 20, 1),
(8, 30, 0);
14 rows affected

select *
from results as r1
where not exists (
    select *
    from requirements as reqd
    where not exists (
        select *
        from results as r2
        where r1.sequence = r2.sequence and r2.intraworkno = reqd.intraworkno
    )
);


sequence
intraworkno
part


2
10
0

2
20
0

2
30
0

8
10
0

8
20
0

8
20
1

8
30
0