MySQL 8.4

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

create table t1 (
  id int,
  name varchar(16)
);
insert into t1 values (1, 'John'), (2, 'Mary'), (null, 'Anonymous');

Records: 3  Duplicates: 0  Warnings: 0

create table t2 (
  id int,
  xxx int
);
insert into t2 values (1, 1), (2, 2), (4, 4);

Records: 3  Duplicates: 0  Warnings: 0

select * from t1 where id in (select id from t2);

id
name

1
John

2
Mary

alter table t2 drop column id;

Records: 0  Duplicates: 0  Warnings: 0

select id from t2;

Unknown column 'id' in 'field list'

select * from t1 where id in (select id from t2);

id
name

1
John

2
Mary