ORACLE 没有 inner join ,left join ,right join 的语法
select a.*,b.* from a,b where a.field1=b.field1 (inner join)
select a.*,b.* from a,b where a.field1=b.field1(+) (left join)
select a.*,b.* from a,b where (+)a.field1=b.field1 (right join)
但是不可以 select a.*,b.* from a,b where (+)a.field1=b.field1(+)
select a.*,b.* from a,b where a.field1=b.field1 (inner join)
select a.*,b.* from a,b where a.field1=b.field1(+) (left join)
select a.*,b.* from a,b where (+)a.field1=b.field1 (right join)
但是不可以 select a.*,b.* from a,b where (+)a.field1=b.field1(+)
不过我想知道“where a.field1=b.field1”与(inner join)方法,速度哪个快些,
它们查询时是如何匹配的?
join 语句在 9i 中才被支持,在 9i 以前的版本中只能使用MayMay911(酸梅子)所说的。