Re: ORA-00904 & left join

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)

>