甲骨文:我需要一个“部分"的解决方案.外连接.看图片 [英] Oracle: I need a "partial" outer join. Look at the image

问题描述

我希望这很清楚.如何获得下图所示的结果?

I hope it's clear. How can I achieve the result showed in the following image?

推荐答案

只做外部联接，也要使用合并

Just do an outer join but also use coalesce

SELECT
   COALESCE(a.master,b.master) master,
   a.ColA,
   b.ColB
FROM
  a FULL OUTER JOIN B
  ON a.master = b.master
     AND (a.ColA = b.ColB 
          or a.ColA is Null
          or b.ColB is Null)
ORDER BY 
    COALESCE(a.master,b.master),
    COALESCE(a.cola,b.colB)

此处

这篇关于甲骨文:我需要一个“部分"的解决方案.外连接.看图片的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！