避免单个表的多个列的多个左连接

create table table1 (people varchar(10), special_id varchar(20));
create table table2 (special_id varchar(20), dependent_value int8, value_wanted varchar(5));

insert into table1 values 
('person1', 'abc'),
('person1', 'abc'),
('person1', 'abc'),
('person1', 'abc'),
('person1', 'bbb'),
('person1', 'bbb'),
('person1', 'ccd');


insert into table2 values
('abc', '02', 'boom'),
('abc', '01', 'zoom'),
('bbb', '01', 'woom'),
('abc', '03', 'whom');

+---------+------------+---------+---------+
| people  | special_id | code_01 | code_02 |
+---------+------------+---------+---------+
| person1 | abc        | zoom    | boom    |
| person1 | abc        | zoom    | boom    |
| person1 | abc        | zoom    | boom    |
| person1 | abc        | zoom    | boom    |
| person1 | bbb        | woom    | NULL    |
| person1 | bbb        | woom    | NULL    |
| person1 | ccd        | NULL    | NULL    |
+---------+------------+---------+---------+

select t1.*, t2.value_wanted as code_01, t2_1.value_wanted as code_02
from table1 t1
left join table2 t2
on t2.special_id = t1.special_id and t2.dependent_value = '01'
left join table2 t2_1
on t2_1.special_id = t1.special_id and t2_1.dependent_value = '02';