select o.*, p.*, c.*
from public.orders o
left join products p on o.product_id = p.id
left join customers c on o.customer_id = c.id
order by o.created_at asc
id|product_id|customer_id|created_at |id|name |price|created_at |id|name |created_at |
--+----------+-----------+-----------------------------+--+-------------+-----+-----------------------------+--+-----+-----------------------------+
3| 2| 1|2022-05-12 10:11:33.000 +0700| 2|XPress Bottle|200.0|2022-01-22 13:30:24.116 +0700| 1|Adams|2022-01-21 12:34:27.156 +0700|
9| 4| 3|2022-05-14 10:48:11.000 +0700| 4|Sharpy Knife |400.0|2022-04-22 12:04:22.756 +0700| 3|Clark|2022-02-24 14:14:24.126 +0700|
7| 2| 3|2022-05-15 10:41:18.000 +0700| 2|XPress Bottle|200.0|2022-01-22 13:30:24.116 +0700| 3|Clark|2022-02-24 14:14:24.126 +0700|
2| 1| 1|2022-05-15 20:22:31.000 +0700| 1|Orbital Keys |100.0|2022-01-21 12:34:27.156 +0700| 1|Adams|2022-01-21 12:34:27.156 +0700|
6| 2| 3|2022-06-19 15:39:16.000 +0700| 2|XPress Bottle|200.0|2022-01-22 13:30:24.116 +0700| 3|Clark|2022-02-24 14:14:24.126 +0700|
11| 3| 2|2022-06-19 20:47:20.000 +0700| 3|Swish Wallet |300.0|2022-04-22 12:04:22.756 +0700| 2|Baker|2022-01-22 13:30:24.116 +0700|
5| 4| 2|2022-07-10 13:30:22.000 +0700| 4|Sharpy Knife |400.0|2022-04-22 12:04:22.756 +0700| 2|Baker|2022-01-22 13:30:24.116 +0700|
10| 3| 3|2022-07-13 11:39:23.000 +0700| 3|Swish Wallet |300.0|2022-04-22 12:04:22.756 +0700| 3|Clark|2022-02-24 14:14:24.126 +0700|
4| 2| 2|2022-07-17 19:11:26.000 +0700| 2|XPress Bottle|200.0|2022-01-22 13:30:24.116 +0700| 2|Baker|2022-01-22 13:30:24.116 +0700|
8| 4| 1|2022-08-10 19:48:46.000 +0700| 4|Sharpy Knife |400.0|2022-04-22 12:04:22.756 +0700| 1|Adams|2022-01-21 12:34:27.156 +0700|
1| 1| 4|2022-08-16 18:20:27.000 +0700| 1|Orbital Keys |100.0|2022-01-21 12:34:27.156 +0700| 4|Davis|2022-02-26 17:32:21.756 +0700|