SQL左连接，右连接，内连接简单例子

SQL左连接，右连接，内连接简单例子

左连接：以左表为主

select column_a , column_b 
from table_a left join table_b 
on table_a.id=table_b.id;

右连接：以右表为主

select *
from table_a right join table_b
on table_a.id = table_b.id;

内连接：值查询两张表符合的记录

select *
from table_a inner join table_b
on table_a.id = table_b.id;

全连接：全都显示，将以前无法显示的空值

select *
from table_a full join table_b
on table_a.id = table_b.id;