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