外连接查询

(表名1:a 表名2:b)

select a.a,a.b,a.c,b.c,b.d,b.f from a left out join b on a.a = b.c

原文地址:https://www.cnblogs.com/wuhuisheng/p/1780746.html