Hi all,

Is there really a reason why would one choose to use

select emp.ename, dept.dname
from emp
INNER JOIN dept
ON emp.deptno = dept.deptno

instead of ...

select emp.ename, dept.dname
from emp, dept
where emp.deptno = dept.deptno

Am just not used to the first one, but nonetheless I want to know maybe
there is some 'hidden' reasons for choosing to use the first one.

Cheers,


EDWIN ONG UY
\\|//
(o o)
^"^"^"^"^"^oOOo"^(_)^"oOOo^"^"^"^"^"^"^"^"^"^"^

"Choose a job you love, and you will never have to work a day in your
life." --Confucius
"How do I work? I grope." -- Albert Einstein
"Experience is the best teacher, enrolling in the class is the biggest
problem." -- Anonymous


Oracle LazyDBA home page