Re: Subquery in Select

Hi,

You can write the same select statement in the from clause.

eg.: select a.ename, b.dname from emp a, (select dname,deptno from

            dept) b where a.deptno = b.deptno;

Bye,
Venu Received on Tue Mar 09 1999 - 16:53:45 CST