上图最下面两个图的查询语句
select ... from 表1 as a FULL OUTER JOIN 表2 as b on a.列名=b.列名 (右)
select ... from 表1 as a FULL OUTER JOIN 表2 as b on a.列名=b.列名 where a.列名 is null or b.列名 is null
select ... from 表1 as a FULL OUTER JOIN 表2 as b on a.列名=b.列名 (右)
select ... from 表1 as a FULL OUTER JOIN 表2 as b on a.列名=b.列名 where a.列名 is null or b.列名 is null