sql语句多表联查

上图最下面两个图的查询语句

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

posted @ 2022-12-07 09:02  当时只道是寻常呀  阅读(181)  评论(0)    收藏  举报