如何在MySQL中合并并从三个不同的相关表中求和？

SELECT *
FROM tableA
JOIN tableB ON tableA.ID = tableB.ID
JOIN tableC ON tableA.ID = tableC.ID;

SELECT *
FROM tableA
JOIN tableB ON tableA.ID = tableB.ID
JOIN tableC ON tableA.ID = tableC.ID
GROUP BY tableA.column;

SELECT SUM(tableB.field) AS total
FROM tableA
JOIN tableB ON tableA.ID = tableB.ID
JOIN tableC ON tableA.ID = tableC.ID
GROUP BY tableA.column;

SELECT tableA.column, SUM(tableB.field) AS total
FROM tableA
JOIN tableB ON tableA.ID = tableB.ID
JOIN tableC ON tableA.ID = tableC.ID
GROUP BY tableA.column;