mysql多左连接查询

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

SELECT table1.column1, table2.column2, table3.column3
FROM table1
LEFT JOIN table2 ON table1.id = table2.table1_id
LEFT JOIN table3 ON table1.id = table3.table1_id
LIMIT 100 OFFSET 0;

CREATE TEMPORARY TABLE temp_table AS
SELECT table1.id, table2.column2, table3.column3
FROM table1
LEFT JOIN table2 ON table1.id = table2.table1_id
LEFT JOIN table3 ON table1.id = table3.table1_id;

SELECT * FROM temp_table;

-- 获取table1和table2的连接结果
SELECT table1.id, table2.column2
INTO temp_table1
FROM table1
LEFT JOIN table2 ON table1.id = table2.table1_id;

-- 获取table1和table3的连接结果
SELECT table1.id, table3.column3
INTO temp_table2
FROM table1
LEFT JOIN table3 ON table1.id = table3.table1_id;

-- 最终结果
SELECT temp_table1.id, temp_table1.column2, temp_table2.column3
FROM temp_table1
LEFT JOIN temp_table2 ON temp_table1.id = temp_table2.id;