SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

subquery referencing column in outer query

452095Nov 30 2005 — edited Nov 30 2005

I have a simplified problem such as...

select	a.year
,	(	select	b.column
		from	table b
		,	(	select	c.year
				from	table c
				where	c.year = b.year  <= ORA-00904 "B"."YEAR": invalid identifier
			)  
		where	b.year = a.year
	) 
from	table a
group by a.year

My question is why am I getting the error? Is there a way around it?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2005

Added on Nov 30 2005

2 comments

886 views