Re: Weird SQL

...sorry, I don't think my other reply was correct.

Isn't is just that you are selecting a column from the IN that doesn't exist in the IN?

SQL> select a from (select 1 b from dual); select a from (select 1 b from dual)

       *
ERROR at line 1:
ORA-00904: "A": invalid identifier

SQL> select a from (select 1 a from dual);

         A

         1

SQL> Regards,

Steve Received on Wed May 17 2006 - 14:53:30 CDT