Oracle8i的左连接问题

[zxbyhcsdn]

问一下哟!!Oracle中的左连接问题!!

select A.fld1,
B.*
from haha A ,(select * from haha where fld2='hehe' ) B
where A.fld1=substr(B.fld1,1,2)(+);
要出错!!
错出在这个地方A.fld1=substr(B.fld1,1,2)(+);

难道(+)左边就不能用函数了么??

8i又不能用Left join

[doulikeme]

放里面行不？

A.fld1=substr(B.fld1(+),1,2);

[YuriOU]

select A.fld1,
B.*
from haha A ,(select * from haha where fld2='hehe' ) B
where A.fld1=substr(B.fld1(+),1,2);

[YuriOU]

或：

select A.fld1,
B.*
from haha A left join
(select * from haha where fld2='hehe' ) B
where A.fld1=substr(B.fld1,1,2);

[YuriOU]

更正：
select A.fld1,
B.*
from haha A left join
(select * from haha where fld2='hehe' ) B
on A.fld1=substr(B.fld1,1,2);

[yown]

select A.fld1,
B.*
from haha A ,(select * from haha where fld2='hehe' ) B
where A.fld1(+)=substr(B.fld1,1,2);