MySQL 8.0

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

CREATE TABLE doTable_critical (
   val_critical INT,
   qs VARCHAR(2),
   code_critical VARCHAR(255),
   code_line VARCHAR(100)
);
CREATE TABLE doTable_report (
   code_line VARCHAR(100)
);
INSERT INTO doTable_critical(val_critical, qs, code_critical, code_line) VALUES (1, 'YS', '4.01 - Passers', 'GX10-13686');
INSERT INTO doTable_critical(val_critical, qs, code_critical, code_line) VALUES (1, 'YS', '3.03 - Chains', 'GX10-13686' );
select *  from doTable_critical;


val_critical
qs
code_critical
code_line


1
YS
4.01 - Passers
GX10-13686

1
YS
3.03 - Chains
GX10-13686


CREATE TABLE Seat_Marker (code_line varchar(20), code_line_1 varchar(20), Passers int, Chains int);

INSERT INTO Seat_Marker 
(code_line, code_line_1, Passers, Chains)
VALUES 
    	( 'GX10-13686', 'GX10-13686', 0, 1 ),
	    ( 'GX10-13686', 'GX10-13686', 1, 0 ),
        ( 'GX11-13686', 'GX11-13686', 0, 1 ),
	    ( 'GX11-13686', 'GX11-13686', 1, 0 ),
        ( 'GX12-13686', 'GX12-13686', 0, 1 ),
	    ( 'GX12-13686', 'GX12-13686', 0, 1 ),
        ( 'GX13-13686', 'GX13-13686', 1, 0 ),
	    ( 'GX13-13686', 'GX13-13686', 1, 0 );

SELECT * FROM Seat_Marker;

Records: 8  Duplicates: 0  Warnings: 0




code_line
code_line_1
Passers
Chains


GX10-13686
GX10-13686
0
1

GX10-13686
GX10-13686
1
0

GX11-13686
GX11-13686
0
1

GX11-13686
GX11-13686
1
0

GX12-13686
GX12-13686
0
1

GX12-13686
GX12-13686
0
1

GX13-13686
GX13-13686
1
0

GX13-13686
GX13-13686
1
0


select code_line,
  CASE 
    WHEN(REGEXP_INSTR(GROUP_CONCAT(DISTINCT Chains), '1', 1) > 0) THEN 1 
    ELSE 0 
  END AS Chains,
  CASE 
    WHEN(REGEXP_INSTR(GROUP_CONCAT(DISTINCT Passers), '1', 1) > 0) THEN 1 
    ELSE 0 
  END AS Passers
  from Seat_Marker
group by code_line


code_line
Chains
Passers


GX10-13686
1
1

GX11-13686
1
1

GX12-13686
1
0

GX13-13686
0
1

code_line	code_line_1	Passers	Chains
GX10-13686	GX10-13686	0	1
GX10-13686	GX10-13686	1	0
GX11-13686	GX11-13686	0	1
GX11-13686	GX11-13686	1	0
GX12-13686	GX12-13686	0	1
GX12-13686	GX12-13686	0	1
GX13-13686	GX13-13686	1	0
GX13-13686	GX13-13686	1	0