Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> ANSI joins
Hai everyone,
I have a doubt on joins.
select e.empno, e.ename, d.loc
from emp e, dept d
where e.deptno = d.deptno
and substr(e.ename,1,1) = 'S';
How can I rewrite it in ANSI compliant equivalent statement usable on the Oracle database?
select empno, ename, loc
from emp join dept
on emp.deptno = dept.deptno
where substr(emp.ename,1,1) = 'S';
or
select empno, ename, loc
from emp join dept
on emp.deptno = dept.deptno
and substr(emp.ename,1,1) = 'S';
Which one of them is right, using WHERE or AND for the last condition?
Do guide me.
Thanks.
BigLearner Received on Sat Dec 02 2006 - 23:13:52 CST
![]() |
![]() |