MySQL实现全连接功能（FULL OUTER JOIN）

MySQL不支持全连接可通过以下方式实现with name_1 as (select 1as id,'张三' as name,20as `number`union allselect 2as id,'李四' as name,30as `number`),name_2 as (select 1as id,

qq_43739780

5709人浏览 · 2022-02-11 17:52:24

qq_43739780 · 2022-02-11 17:52:24 发布

MySQL不支持全连接

可通过以下方式实现

with name_1 as (
    select 1    as id,
           '张三' as name,
           20   as `number`
    union all
    select 2    as id,
           '李四' as name,
           30   as `number`
),
     name_2 as (
         select 1    as id,
                '张三' as name,
                10   as `number`
         union all
         select 3    as id,
                '王五' as name,
                30   as `number`
     )
SELECT *
FROM name_1 A
         left outer join name_2 B
                         on a.id = b.id
union
SELECT *
FROM name_1 A
         right outer join name_2 B
                          on a.id = b.id