select * from yourtable1 , yourtable2
where yourtable1.col1(+) = yourtable2.col2
回复人： beckhambobo(beckham) ( ) 信誉：105 2003-2-17 14:41:05 得分:5
左连接col1=col1(+)//+在右边是左连接，相应的在左边是右连接
右连接col1(+)=col1
回复人： black_snail() ( ) 信誉：120 2003-2-17 15:40:24 得分:70
table1
code name
1 Jack
2 Mike
table2
code name
1 jack
3 Rose
left join;
select table1.code , table1.name , table2.code , table2.name
from table1,table2
where table1.code (+) = table2.code
result :
code name code name
1 Jack 1 Jack
2 Mike
right join;
select table1.code , table1.name , table2.code , table2.name
from table1,table2
where table1.code = table2.code(+)
result :
code name code name
1 Jack 1 Jack
3 Rose
normal join;
select table1.code , table1.name , table2.code , table2.name
from table1,table2
where table1.code = table2.code
result :
code name code name
1 Jack 1 Jack
join everything ;
select table1.code , table1.name , table2.code , table2.name
from table1,table2
where table1.code(+) = table2.code
Union
select table1.code , table1.name , table2.code , table2.name
from table1,table2
where table1.code = table2.code(+)
result :
code name code name
1 Jack 1 Jack
2 Mike
3 Rose下载本文
