SELECT * FROM TEST2 T1,TEST3 T2 WHERE T1.C2 = T2.NAME(+);  
--T1三列,T2为三列,以T1表为基础表,结果显示六列,T1表全显示, T2表显示T1.C2 = T2.NAME(+)相关联的数据。    
SELECT * FROM TEST2 T1,TEST3 T2 WHERE T1.C2(+) = T2.NAME;  
--T1三列,T2为三列,以T2表为基础表,结果显示六列,T2表全显示, T1表显示T1.C2(+) = T2.NAME相关联的数据。    
SELECT * FROM TEST2 T1,TEST3 T2 WHERE T1.C2 = T2.NAME;  
--T1三列,T2为三列,结果显示六列,显示T1.C2 = T2.NAME相关联的数据。