Re: Help getting around Outer Join limitation

From: mark tomlinson <marktoml_at_gdi.net>
Date: 1998/02/03
Message-ID: <34d84cd5.330074081@newshost.us.oracle.com>#1/1

try using ODBC syntax rather than Oracle syntax:

Oracle Join:

---

select dept.deptno, sum(sal)
from dept, emp
where emp.deptno(+) = dept.deptno
group by dept.deptno

ODBC Join:

---

select dept.deptno, sum(sal)
from {oj dept left outer join emp
on dept.deptno = emp.deptno}
group by dept.deptno Received on Tue Feb 03 1998 - 00:00:00 CST