Search Again: Re: Joins-. From: Marcio Portes Date: Sunday, January 18, 2004 Time: 3:24:10 am Gustavo, That syntax is support in Oracle9i and up. scott@MRP920> select emp.* 2 from emp left join dept 3 on (emp.deptno =3D dept.deptno) 4 / EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO ---------- ---------- --------- ---------- --------------------- ---------- ---------- ---------- 7369 SMITH CLERK 7902 17/12/1980 - 00:00:00 800 20 7499 ALLEN SALESMAN 7698 20/02/1981 - 00:00:00 1600 300 30 7521 WARD SALESMAN 7698 22/02/1981 - 00:00:00 1250 500 30 7566 JONES MANAGER 7839 02/04/1981 - 00:00:00 2975 20 7654 MARTIN SALESMAN 7698 28/09/1981 - 00:00:00 1250 1400 30 7698 BLAKE MANAGER 7839 01/05/1981 - 00:00:00 2850 30 7782 CLARK MANAGER 7839 09/06/1981 - 00:00:00 2450 10 7788 SCOTT ANALYST 7566 19/04/1987 - 00:00:00 3000 20 7839 KING PRESIDENT 17/11/1981 - 00:00:00 5000 10 7844 TURNER SALESMAN 7698 08/09/1981 - 00:00:00 1500 0 30 7876 ADAMS CLERK 7788 23/05/1987 - 00:00:00 1100 20 7900 JAMES CLERK 7698 03/12/1981 - 00:00:00 950 30 7902 FORD ANALYST 7566 03/12/1981 - 00:00:00 3000 20 7934 MILLER CLERK 7782 23/01/1982 - 00:00:00 1300 10 14 rows selected. -- Marcio Portes marcio.portes@uol.com.br uin#112511323

Messages In This Thread: Joins-. by Gustavo Guitera V.I.A. on Jan 5, 2004 at 11:12:29 am Re: Joins-. by Marcio Portes on Jan 18, 2004 at 3:24:10 am