Re: ORA-00904 & left join

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)