全外联
2020-11-21 11:29:49
SQLServer
admin
sql中的全外联区别与左联接与右联接,它会按将on语句指明的条件,将左表与右表两个表的所有记录都查询出来,没有值的字段返回null,全外联的关键字是fullouterjoin,下面是全外联的一个sql示例:selecth.RKNumber,
sql中的全外联区别与左联接与右联接,它会按将on语句指明的条件,将左表与右表两个表的所有记录都查询出来,没有值的字段返回null,全外联的关键字是fullouterjoin,下面是全外联的一个sql示例:
selecth.RKNumber,isnull(h.GID,i.GID)asGID,i.GIDasGID1,i.CKNumberfrom(
selectSum(c.Number)asRKNumber,c.GIDfrom
(selectb.GID,b.NumberfromStorage_RKMasteraleftjoinStorage_RKDetailb
ona.RKID=b.RKIDwhereb.GIDisnotnull)cGroupbyc.GID
)hfullouterjoin
(
selectSum(g.Number)asCKNumber,g.GIDfrom
(selectf.GID,f.NumberfromStorage_CKMastereleftjoinStorage_CKDetailf
one.CKID=f.CKIDwheref.GIDisnotnull)gGroupbyg.GID
)ionh.GID=i.GID
selecth.RKNumber,isnull(h.GID,i.GID)asGID,i.GIDasGID1,i.CKNumberfrom(
selectSum(c.Number)asRKNumber,c.GIDfrom
(selectb.GID,b.NumberfromStorage_RKMasteraleftjoinStorage_RKDetailb
ona.RKID=b.RKIDwhereb.GIDisnotnull)cGroupbyc.GID
)hfullouterjoin
(
selectSum(g.Number)asCKNumber,g.GIDfrom
(selectf.GID,f.NumberfromStorage_CKMastereleftjoinStorage_CKDetailf
one.CKID=f.CKIDwheref.GIDisnotnull)gGroupbyg.GID
)ionh.GID=i.GID
很赞哦! ()
- 上一篇: Union 多个记录集合成一个记录集
- 下一篇: 返回列表