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