Joins

Dear buddies,

I am a new member to this group.

Looking forward to build up myself towards future.

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 - 00:38:48 CST