ORA-00904 & left join

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 Received on Tue Oct 21 2003 - 10:42:46 CDT