oracle8i不支持ANSI SQL 92标准中left join的语法,但是left join的功能是可以通过+来实现 for instance: --unsupported ansi sql92 syntax Select T1.f1,t1.f2,,t2.f2 as f3 from t1 left join t2 on t1.f1=t2.f1--oracle 8i implementation Select T1.f1,t1.f2,,t2.f2 as f3 from t1 ,t2 where t1.f1=t2.f1(+)
Select T1.f1,t1.f2,,t2.f2 as f3 from t1 ,t2 where t1.f1=t2.f1(+)
都是sql92标准
--unsupported ansi sql92 syntax
Select T1.f1,t1.f2,,t2.f2 as f3
from t1 left join t2 on t1.f1=t2.f1--oracle 8i implementation
Select T1.f1,t1.f2,,t2.f2 as f3
from t1 ,t2
where t1.f1=t2.f1(+)