ame, b.address
FROM table1 a
LEFT JOIN table2 b ON a.id = b.id;
ame, b.address
FROM table1 a
RIGHT JOIN table2 b ON a.id = b.id;
ame, b.address
FROM table1 a
FULL OUTER JOIN table2 b ON a.id = b.id;
1. 多表關聯查詢
2. 數據庫備份和恢復
3. 數據庫性能優化
ame, b.address
FROM table1 a
LEFT JOIN table2 b ON a.id = b.id;
ame, b.address
FROM table1 a
RIGHT JOIN table2 b ON a.id = b.id;
ame, b.address
FROM table1 a
FULL OUTER JOIN table2 b ON a.id = b.id;
1. 多表關聯查詢
2. 數據庫備份和恢復
3. 數據庫性能優化