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

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00904 & left join

Re: ORA-00904 & left join

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Tue, 21 Oct 2003 10:58:06 -0700
Message-ID: <1066759099.389066@yasure>


Jonathan Lewis wrote:

>Daniel,
>
>He probably got the syntax from the Oracle 9 manuals.
>
>The phrase "I've never seen that before" should not
>be translated into "It must be wrong" too quickly.
>
>Oracle introduced ANSI joins in Oracle 9 - I still
>have to think very carefully when I see them of
>try to write them, but they are documented.
>
>--
>Regards
>
>Jonathan Lewis
>http://www.jlcomp.demon.co.uk
>
> The educated person is not the person
> who can answer the questions, but the
> person who can question the answers -- T. Schick Jr
>
>
>One-day tutorials:
>http://www.jlcomp.demon.co.uk/tutorial.html
>____Belgium__November (EOUG event - "Troubleshooting")
>____UK_______December (UKOUG conference - "CBO")
>
>
>Three-day seminar:
>see http://www.jlcomp.demon.co.uk/seminar.html
>____UK___November
>
>
>The Co-operative Oracle Users' FAQ
>http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
>news:1066751182.356553_at_yasure...
>
>
>>Fabio wrote:
>>
>>
>>
>>>Oracle 9i:
>>>Situation:
>>>
>>> create table v(x number, y varchar2(10));
>>> create table b(z number, w varchar2(10));
>>> create table t(h number, k varchar2(10));
>>>
>>>-- OK
>>>1)
>>>select v.*
>>>from
>>>v left join (b inner join t on b.Z = t.H) on v.X = t.H
>>>
>>>-- error ORA-00904
>>>2)
>>>select v.x, v.y
>>>from
>>>v left join (b inner join t on b.Z = t.H) on v.X = t.H
>>>
>>>-- OK
>>>
>>>What's wrong in the query 1 ??
>>>
>>>Thanks
>>>Fabio
>>>
>>>
>>>
>>>
>>>
>>The syntax? Where did you get the idea that you could write this in
>>Oracle? Oracle is Oracle ...
>>it is not a Microsoft product.
>>
>>Go to http://tahiti.oracle.com and look up the correct syntax.
>>
>>--
>>Daniel Morgan
>>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
>>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
>>damorgan_at_x.washington.edu
>>(replace 'x' with a 'u' to reply)
>>
>>
>>

Surely you are kidding ... and yet I know you are not.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Tue Oct 21 2003 - 12:58:06 CDT

Original text of this message

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