15,059
edits
Visual explanation of MySQL joins: Difference between revisions
Jump to navigation
Jump to search
→狀況 2: 交集的資料，同時存在於 a 和 b
mNo edit summary |
|||
| Line 119: | Line 119: | ||
SELECT a.*, b.* FROM table_a AS a NATURAL JOIN table_b AS b; | SELECT a.*, b.* FROM table_a AS a NATURAL JOIN table_b AS b; | ||
-- INNER JOIN 寫成 JOIN | |||
SELECT * FROM table_a | |||
JOIN table_b | |||
ON table_a.id = table_b.id; | |||
</pre> | </pre> | ||