SQL语法——Join详解

一、INNER JOIN

用法：

select column_name(s)

from table 1

INNER JOIN table 2

ON

table 1.column_name=table 2.column_name

例子：

　两个表：three,user

select* from three inner join user;

select* from three inner join user on three.id = user.id;

用法：

select column_name(s)

from table 1

LEFT JOIN table 2

ON table 1.column_name=table 2.column_name

例子：

select * from three left join user on three.id=user.id;

用法：

select column_name(s)

from table 1

RIGHT JOIN table 2

ON table 1.column_name=table 2.column_name

例子：

select * from three right join user on three.id=user.id;

用法：

select column_name(s)

from table 1

FULL OUTER JOIN table 2

ON table 1.column_name=table 2.column_name

例子：

select * from three full outer join user on three.id=user.id;

mysql 报错不支持full join ,但是可以用下面的这种写法取代：

select * from three left outer join user on three.id=user.id union select * from three right outer join user on three.id=user.id；