Mysql 多表连接查询

Mysql 多表连接查询

多表连接查询

inner join 内查询 ，一般 inner 可以省略

SELECT 
u.id,u.name,
u_r.user_id
FROM USER u
INNER JOIN user_role u_r ON (u_r.user_id=u.id)

left join 左查询

SELECT 
u.id,u.name,
u_r.user_id
FROM USER u
LEFT JOIN user_role u_r ON (u_r.user_id=u.id)

right join 右查询

SELECT 
u.id,u.name,
u_r.user_id
FROM USER u
RIGHT JOIN user_role u_r ON (u_r.user_id=u.id)