mysql中的join

inner join只显示满足on后面条件的的列
select table1.column1, table2.column2 as rename
from table1
inner join table2
on table1.column2=table2.column2;
输出结果仅为满足table1.column2=table2.column2的table1.column1,和table2.column2


left join会输出from后面的表中的列，若其中有不满足于on后面条件的值则left join后的表的对应值用null代替
select table1.column1, table2.column2 as rename
from table1
left join table2
on table1.column2=table2.column2;
输出结果为table1.column1中所有值，table2中不满足table1.column2=table2.column2的值显示为null


right join的情况则与left join相反


full join则是right join和left join的结合，同时列出两个的结果


结尾可以加上order by table.column进行排序


在有些数据库中也用outer join代替join