SQL JOINS

[DCP]

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

[Bricklen]

DCP wrote: 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
QUIT SHOUTING

What version of Oracle are you running?

[DCP]

Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production

[DCP]

Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production

[Bricklen]

DCP wrote: Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
I don't think that 8i supported the outer join syntax, IIRC.
Try using the (+) syntax

see docs.oracle.com for more details
or
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/expressi.htm#1023213

[Mark C. Stock]

"Bricklen" <bricklen@zyahoo.zcomz> wrote in message
news:7NZ6d.85$MV5.60@clgrps13...
| DCP wrote:
| > Oracle8i Enterprise Edition Release 8.1.7.3.0 - Production
| >
| I don't think that 8i supported the outer join syntax, IIRC.
| Try using the (+) syntax
|
| see docs.oracle.com for more details
| or
|
http://download-west.oracle.com/docs/cd/A87860_01/doc/server.817/a85397/expressi.htm#1023213

you recall correctly

++ mcs

[DCP]

Its working with (+), but i want full outer join for tables. so how i have
to do that in 8i, we can't put (+) on both sides, that gives an error

[Mark C. Stock]

"DCP" <vaagh@hotmail.com> wrote in message
news:694b8886a926f0e9e0fdc2a7cbf03c8c@localhost.talkaboutdatabases.com...
| Its working with (+), but i want full outer join for tables. so how i have
| to do that in 8i, we can't put (+) on both sides, that gives an error
|

you've got to do a UNION of the left outer join and the right outer join :-(

++ mcs

[Arangaperumal]

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

left join UNION right join



"DCP" <vaagh@hotmail.com> wrote in message news:<68597cadc5d2e5af2975b61abb8098b1@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

[DCP]

thanks very much

[DCP]

Sorry to be late to thank you