MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT VERSION();


VERSION()


8.0.25


DROP TABLE IF EXISTS `contacts`, `orders`;

CREATE TABLE IF NOT EXISTS `orders` (
  `id` serial,
  `Campaign` VARCHAR(100),
  `exclude_from_statistics` bool
);

CREATE TABLE IF NOT EXISTS `contacts` (
  `Contact ID` BIGINT UNSIGNED,
  `Great Benefactor` BOOL
);

INSERT INTO `orders`
  (`exclude_from_statistics`, `Campaign`)
VALUES
  (0, 'nuit'),
  (1, 'no-nuit'),
  (0, 'no-nuit');

INSERT INTO `contacts`
  (`Contact ID`, `Great Benefactor`)
VALUES
  (1, false),
  (2, false),
  (3, true);
SELECT
  `id`,
  `Campaign`,
  `exclude_from_statistics`
FROM
  `orders`;

SELECT
  `Contact ID`,
  `Great Benefactor`
FROM
  `contacts`;


id
Campaign
exclude_from_statistics


1
nuit
0

2
no-nuit
1

3
no-nuit
0




Contact ID
Great Benefactor


1
0

2
0

3
1


UPDATE `orders`
  INNER JOIN `contacts` ON
    `orders`.`id` = `contacts`.`Contact ID`
SET
  `orders`.`exclude_from_statistics` =
  IF(
    `contacts`.`Great Benefactor` = TRUE OR
    `orders`.`Campaign` = 'nuit',
    1,
    0
  );
SELECT
  `id`,
  `Campaign`,
  `exclude_from_statistics`
FROM
  `orders`;

SELECT
  `Contact ID`,
  `Great Benefactor`
FROM
  `contacts`;


id
Campaign
exclude_from_statistics


1
nuit
1

2
no-nuit
0

3
no-nuit
1




Contact ID
Great Benefactor


1
0

2
0

3
1