MYSQL:INNER JOIN的用法
- inner join的用处:使用于多表查询
- 关键字:on
- on:后面直接跟条件表达式
实例
代码块
select u.user_name,i.info_phone from user u
inner join userInfo i on
u.user_id=i.user_id
select u.user_name,i.info_phone from user u
inner join userInfo i on
u.user_id=i.user_id