2011-08-01 10:19
最佳答案
oracle中的(+)是一种特殊的用法,(+)表示外连接,并且总是放在非主表的一方。 例如左外连接: select A.a,B.a from A LEFT JOIN B ON A.b=B.b; 等价于 select A.a,B.a from A,B where A.b = B.b(+); 再举个例子,这次是右外连接: select A.a,B.a from A RIGHT JOIN B 4039180_cpr&fenlei=mv6quAkxTZn0IZRqIHcvrjTdrH00T1d9PywbPWfsuhcdPH9-nyD30ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3En10sPHcvPW6d" class="baidu-highlight" rel="@R_403_104@" style="color:rgb(63,B where A.b (+) = B.b; 明白了记得给分!