full outer join舍去交集

full outer join不会舍去交集，它会将左表和右表中的所有记录都包括在结果中，并将交集部分也包括在内。full outer join会返回左表和右表中的所有记录，如果某个记录在左表中存在但在右表中不存在，或者在右表中存在但在左表中不存在，那么对应的字段值将会显示为空值。所以full outer join不会舍去交集部分的记录。\[3\]
#### 引用[.reference_title]
- *1* *2* [sql关键字 左连接 右连接 外连接 交叉连接 交集 并集 差集 批量更新/删除](https://blog.csdn.net/weixin_30827565/article/details/98622539)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down28v1,239^v3^insert_chatgpt"}} ] [.reference_item]
- *3* [sql中的join(1)：join,left join,right join,left outer join,right outer join,union,cross join](https://blog.csdn.net/qq_37674086/article/details/109513149)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down28v1,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]