SELECT *
FROM 表格A INNER JOIN 表格B
ON(表格A.欄位 = 表格B.欄位 )
注意
及JOIN 是一樣的
例:
SELECT *
FROM user AS u
INNER JOIN occupation AS o
ON(u.id = o.user_id);
等同
SELECT *
FROM user AS u
JOIN occupation AS o
ON(u.id = o.user_id);
結果:
其它文章