MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table table_A (
  id integer, 
  val1 varchar(5), 
  val2 integer, 
  val3 integer, 
  status integer
  );
insert into table_A values 
(1, 'aaa', 430, 40, 1), 
(2, 'bbb', 760, 45, 2), 
(3, 'ccc', 650, 90, 1), 
(4, 'ddd', 680, 30, 1), 
(5, 'eee', 200, 20, 2);

Records: 5  Duplicates: 0  Warnings: 0


create table table_B (
  id integer, 
  t1_id integer, 
  tb_1 varchar(5), 
  tb_2 varchar(5)
  );
insert into table_B values 
(1, 1, 'a', 'aa'), 
(2, 2, 'b', 'bb'), 
(3, 2, 'c', 'cc'), 
(4, 2, 'd', 'dd'), 
(5, 3, 'e', 'ee'), 
(6, 4, 'f', 'ff'), 
(7, 5, 'g', 'gg'), 
(8, 5, 'h', 'hh');

Records: 8  Duplicates: 0  Warnings: 0


select 
 a.val1, 
 a.val2, 
 a.val3, 
 b.tb_1, 
 b.tb_2
from table_A a
join table_B b
  on a.id = b.t1_id
where a.status = 2


val1
val2
val3
tb_1
tb_2


bbb
760
45
b
bb

bbb
760
45
c
cc

bbb
760
45
d
dd

eee
200
20
g
gg

eee
200
20
h
hh