MySQL 8.0

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

select @@version;


@@version


8.0.18


CREATE TABLE orders
( id INT(20) NOT NULL,
  valid INT(20) NOT NULL,
  CONSTRAINT order_id_pk PRIMARY KEY (id)
);
CREATE TABLE order_line_item
( id INT(20) NOT NULL,
  order_id INT(20) NOT NULL,
  active_orders INT(20),
  CONSTRAINT order_line_item_pk PRIMARY KEY (id),
  FOREIGN KEY fk_order(order_id)
  REFERENCES orders(id)
);
insert into orders (id,valid) values 
(1,1),(2,1),(3,0),(4,1),(5,1);
insert into order_line_item (id,order_id) values
(1,1),(2,2),(3,3),(4,4),(5,5);
update order_line_item oli
inner join orders o
set oli.active_orders = o.valid
where oli.order_id = o.id
select * from order_line_item;


id
order_id
active_orders


1
1
1

2
2
1

3
3
0

4
4
1

5
5
1