将3个表聚合到json postgresql

CREATE TABLE Table1 (
   id INT PRIMARY KEY,
   name VARCHAR(50)
);

CREATE TABLE Table2 (
   id INT PRIMARY KEY,
   age INT
);

CREATE TABLE Table3 (
   id INT PRIMARY KEY,
   address VARCHAR(100)
);

INSERT INTO Table1 VALUES (1, 'John');
INSERT INTO Table1 VALUES (2, 'Jane');

INSERT INTO Table2 VALUES (1, 25);
INSERT INTO Table2 VALUES (2, 30);

INSERT INTO Table3 VALUES (1, '123 Main St');
INSERT INTO Table3 VALUES (2, '456 Elm St');

SELECT json_build_object(
   'Table1', json_agg(json_build_object('id', t1.id, 'name', t1.name)),
   'Table2', json_agg(json_build_object('id', t2.id, 'age', t2.age)),
   'Table3', json_agg(json_build_object('id', t3.id, 'address', t3.address))
) AS aggregated_data
FROM Table1 t1, Table2 t2, Table3 t3
WHERE t1.id = t2.id AND t1.id = t3.id;

{
   "Table1": [
      {
         "id": 1,
         "name": "John"
      },
      {
         "id": 2,
         "name": "Jane"
      }
   ],
   "Table2": [
      {
         "id": 1,
         "age": 25
      },
      {
         "id": 2,
         "age": 30
      }
   ],
   "Table3": [
      {
         "id": 1,
         "address": "123 Main St"
      },
      {
         "id": 2,
         "address": "456 Elm St"
      }
   ]
}