SQL Server 2017

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

create table table1 (ID int, Name varchar(100));
insert into table1 values(1,'CoverLetter'),
(2,'AccountingReceipt'),
(3,'IdlePeriodConfirmation'),
(4,'Contract'),
(5,'BonusPeriodConfirmation');
5 rows affected

create table table2 (ID int, ClubID int,LayoutID int);

insert into table2 values(1,1,1),
(2,2,1),
(3,1,2),
(4,2,4);
4 rows affected

create table table3 ( ID int ,Name varchar(100));
insert into table3 values(1,'Club1'),(2,'Club2');
2 rows affected

with cte aS
(select t3.ID,t2.ClubID,t2.LayoutID
 from Table3 t3 
join Table2 t2 on t3.ID=t2.ClubID
where t2.ClubID=1 -- you can change this condition as you need
) select t1.id,t1.name from table1 t1
 left join cte on t1.ID=cte.LayoutID
 where cte.LayoutID is null


id
name


3
IdlePeriodConfirmation

4
Contract

5
BonusPeriodConfirmation