Re: ORA-00904 & left join

I've tried this on 9.2.0.4 - both versions give the same result. Unless you have a typo in the original that does not appear in the example, then it looks like a bug.

One possibility - assuming your example is a simplified version of the original, perhaps there is something in the column names
that allows for an ambiguous output from the B/T join that results in an internal rename of the columns, and therefore makes the join to V illegal in some strange way. (This is called 'grasping at straws' and is not really a reasonable argument).

--
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


"Fabio" <nonce_at_nulla.it> wrote in message
news:Wtclb.56199$e6.1994856_at_twister2.libero.it...


> 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

>

>