15,017
edits
Visual explanation of MySQL joins: Difference between revisions
Jump to navigation
Jump to search
→狀況 1-1: 以 a 資料為主，再把 b 資料黏上
No edit summary |
|||
| Line 55: | Line 55: | ||
SELECT * FROM table_a | SELECT * FROM table_a | ||
LEFT JOIN table_b | LEFT JOIN table_b | ||
ON table_a.id = table_b.id; | |||
/*相同效果的別種寫法*/ | |||
SELECT * FROM table_a | |||
LEFT OUTER JOIN table_b | |||
ON table_a.id = table_b.id; | ON table_a.id = table_b.id; | ||
</pre> | </pre> | ||