SELECT *FROM TABLE1 A,TABLE2 B WHERE A.ID(+)=B.ID;
右连接=RIGHT JOIN
SELECT *FROM TABLE1 A,TABLE2 B WHERE A.ID=B.ID(+);
左链接=LEFT JOIN
即:+在等号左侧,是右连接; +在等号右侧,是左连接
SELECT *FROM TABLE1 A,TABLE2 B WHERE A.ID(+)=B.ID;
右连接=RIGHT JOIN
SELECT *FROM TABLE1 A,TABLE2 B WHERE A.ID=B.ID(+);
左链接=LEFT JOIN
即:+在等号左侧,是右连接; +在等号右侧,是左连接
转载于:https://www.cnblogs.com/mySummer/p/11019355.html