MySQL 8.0

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

create table table1(column1 int);
create table table2(column2 int);
insert into table1 values(1);
insert into table1 values(2);
insert into table1 values(3);
insert into table1 values(4);

insert into table2 values(2);
insert into table2 values(3);
select column1, (case when column2 is not null then 'Present' else Null end) Column3 
from table1 left join table2 on column1=column2


column1
Column3


1
null

2
Present

3
Present

4
null