Re: Invalid column name

"Christian" <c> wrote in message
news:428e3c81$0$26071$7a628cd7_at_news.club-internet.fr...
> 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...

1. post the statement that causes the error
2. you probably need to order by column position, not column name, since you're using set operators

++ mcs Received on Fri May 20 2005 - 16:00:15 CDT