MySQL 8.0

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

CREATE TABLE invoice (
  id INT,
  loadNumber INT,
  amountUsd INT
);
INSERT INTO invoice VALUES
  (1, 1700, 3575),
  (2, 1453, 7200),
  (3, 1322, 1600),
  (4, 1343, 4350),
  (5, 1133, 500);

Records: 5  Duplicates: 0  Warnings: 0


CREATE TABLE carriersPayments (
  id INT,
  loadNumber INT,
  amountUsd INT
);
INSERT INTO carriersPayments VALUES
  (1, 1700, 3300),
  (2, 1453, 6500),
  (3, 1322, 1400),
  (4, 1343, 4000),
  (5, 1133, 200),
  (6, 1133, 100);

Records: 6  Duplicates: 0  Warnings: 0


SELECT i.id, i.loadNumber, i.amountUsd - SUM(cp.amountUsd) AS PROFIT 
FROM invoice i INNER JOIN carriersPayments cp ON i.loadNumber = cp.loadNumber
GROUP BY i.id, i.loadNumber, i.amountUsd


id
loadNumber
PROFIT


1
1700
275

2
1453
700

3
1322
200

4
1343
350

5
1133
200