Re: SQL JOINS

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 Thu Oct 07 2004 - 06:09:31 CEST