Invalid column name

Hello,

If I do :

     (select 0, c.*
from table1 c
minus
select distinct 0, a.*
from table1 a,table2 b
where ... )
union
select distinct 1, a.*
from table1 a, table2 b
where ...

it works fine.

But if I want to add "order by" and any column from table1 I get "ORA-00904 invalid column name"

I don't understand :-(

Thanks in advance for any idea... Received on Fri May 20 2005 - 14:37:41 CDT