I just realized I performed the wrong query - I should have used (b + 1)! If no one queries this on Oracle in the meantime, I will try it again tomorrow at work.
Sorry for the noise. --- Joe Wilson <[EMAIL PROTECTED]> wrote: > Oracle 8.1.7: > > select a, (select c from (select d + 1 as c from dual) ) as d > from (select 1 as a, 2 as b from dual) > > ORA-00904: invalid column name > > If you replace (d + 1) with a number this query runs fine. > > Perhaps it isn't a valid correlated subquery. > Anyone know the SQL spec well enough to comment? > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
