全连接比较常用的写法是(假定A,B表要求全连接):
SELECT A.COL1, A.COL2, ..., B.COL1, B.COL2, ...
FROM A, B
WHERE A.ID = B.ID (+)
AND ...
UNION ALL
SELECT A.COL1, A.COL2, ..., B.COL1, B.COL2, ...
FROM A, B
WHERE B.ID = A.ID (+)
AND A.ID IS NULL
AND ...;
左連,右連就不用多說了.....
Oracle 外連接
最新推荐文章于 2023-10-31 14:33:42 发布