OraFAQ Forum: Unix » OuterJoint

Home » Infrastructure » Unix » OuterJoint

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

OuterJoint [message #97925]

Fri, 13 June 2003 13:09

WebScientist
Messages: 1
Registered: June 2003

Junior Member

Can someone shud somelight on using the outer joint with (+) on both sides of the "where caluse".

Report message to a moderator

Re: Full Outer Join [message #97926 is a reply to message #97925]

Fri, 13 June 2003 14:12

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

Syntactically in 8i, you cannot put the outer join indicator on both "sides" of the WHERE clause:

SQL> SELECT e.ename
  2  ,      d.dname
  3  FROM   emp      e
  4  ,      dept     d
  5  WHERE  e.deptno (+) = d.deptno (+)
  6  /
WHERE  e.deptno (+) = d.deptno (+)
                    *
ERROR at line 5:
ORA-01468: a predicate may reference only one outer-joined table
  
  
SQL>

For your options in both 8i and 9i, click on the following link:

Full Outer Joins

Good luck,

A

Report message to a moderator

Previous Topic:	Korn shell script
Next Topic:	Mailx

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 19:34:46 CST 2024