left join和left outer join的区别

select a.*,b.* from a left join b on a.k = b.k
select a.*,b.* from a left outer join b on a.k =b.k
----------上面两种一样left join是left outer join的简写

也很及时说：

left join是left outer join的缩写

right join与right outer join的区别也类似

join 与 inner join也类似
————————————————
版权声明：本文为CSDN博主「道法—自然」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/wyqwilliam/article/details/82709496