Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL JOINS

Re: SQL JOINS

From: Arangaperumal <gaperumal_at_hotmail.com>
Date: 6 Oct 2004 21:09:31 -0700
Message-ID: <5b7fac1d.0410062009.19256d01@posting.google.com>


Since 8i does not support this,
Use the following style

left join UNION right join

"DCP" <vaagh_at_hotmail.com> wrote in message news:<68597cadc5d2e5af2975b61abb8098b1_at_localhost.talkaboutdatabases.com>...
> I HAVE FOLLOWING CODE
> I COUDN'T FIND WHAT'S WRONG WITH IT?
>
> select a.name, b.name
> from EMP a full outer join EMP2 b
> on a.eno=b.eno
>
>
> gives error at line 3
>
> SQL command not properly ended FULL
> *
>
> IF ANY BODY CAN GIVE ME A SOLUTION, I WILL APPRECIATE.
>
> tHANKS
> DCP
Received on Wed Oct 06 2004 - 23:09:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US