inner join(又叫join) out join包括left join,right join和full join(也就是left+right) 转载于:https://www.cnblogs.com/youguess/p/4580288.html