strange behaviour of my query

Hi to all

I have this query

select a.* -- a is a view
from a left join (b inner join c on b.f1 = c.f1) on a.f3 = c.f3

that give me a ORA-00904 error on "a" view but if I modify it like this

select a.f1, a.f2 ...
from a left join (b inner join c on b.f1 = c.f1) on a.f3 = c.f3

it works.
What is the trick ?

Thanks in advance
Fabio Received on Thu Jul 17 2003 - 07:30:13 CDT