How to join 3 tables in postgresql via with statement?

Member

by aubrey , in category: MySQL , a month ago

How to join 3 tables in postgresql via with statement?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by jerad , a month ago

@aubrey 

You can join 3 tables in PostgreSQL using the WITH statement by first creating common table expressions (CTEs) for each of the tables you want to join. Here's an example to demonstrate how you can join 3 tables using the WITH statement:

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
WITH table1 AS (
    SELECT * 
    FROM table1_name
),
table2 AS (
    SELECT * 
    FROM table2_name
),
table3 AS (
    SELECT * 
    FROM table3_name
)

SELECT *
FROM table1
JOIN table2 ON table1.id = table2.id
JOIN table3 ON table1.id = table3.id;


In this example, we created CTEs for each of the 3 tables (table1, table2, and table3) and then joined them together using the JOIN clause. You can customize the SELECT statement based on the columns you want to retrieve or any specific conditions you want to apply for the join.