SQL INNER JOIN 关键字
sql inner join 关键字
返回两个表中存在匹配关系的记录。
1. inner join 语法
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;