outer joins

Thread View: net.database

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by roth Thu, 22 Aug 1985 20:16

#111

Author: roth
Date: Thu, 22 Aug 1985 20:16

11 lines
975 bytes

It has been rumored that ORACLE supports outer join and
"it was as easy as adding a plus sign '+'
to the relation that you knew might not have a qualifying tuple". 

First can anyone provide me with a example of how ORACLE employs this, and
second, are there any other languages or proposals for languages which
support outer join.  I am specifically interested in SQL-like languages.

Thanks for your help.

Mark Roth

Re: outer joins

#132

Author: David St. Pierre
Date: Sun, 25 Aug 1985 18:47

22 lines
1163 bytes

I'll borrow the example from the ORACLE manual:

"List all departments that have employees, plus those departments
that do not have employees"

SELECT dept.deptno, dname, job, ename
	from	dept, emp
	where	dept.deptno = emp.deptno(+)
	order	by dept.deptno;


Also:

"List all departments that do not have any employees"

SELECT distinct dept.deptno, dname, koc
	from	dept, emp
	where	dept.deptno = emp.deptno(+)
	  and	empno is null;
-- 
David St. Pierre		{ihnp4,dual,qantel}!ptsfa!dsp

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads