SQL INNER JOIN 關(guān)鍵字
sql inner join 關(guān)鍵字
返回兩個(gè)表中存在匹配關(guān)系的記錄。
1. inner join 語(yǔ)法
select column_name(s)
from table1
inner join table2
on table1.column_name=table2.column_name;
from table1
inner join table2
on table1.column_name=table2.column_name;