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