SQLite 3.39

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

create table Tasks (
  task_id int,	
  task_name varchar(20)
);
✓
insert into Tasks values
(1,	'2D'),
(2,	'3D');
✓
create table Codes (
  code_id int,	
  code_name	varchar(20),
  for_2D  int,	
  for_3D  int
);
✓
insert into Codes values
(1,	'code1',	0,	1),
(2,	'code2',	1,	0),
(3,	'code3',	1,	1)
✓
SELECT code_id, task_id
FROM Codes c
INNER JOIN Tasks t ON ( c.for_2D = 1 AND t.task_name = '2D' )
                      OR ( c.for_3D = 1 AND t.task_name = '3D')


code_id
task_id


1
2

2
1

3
1

3
2