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
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