Re: Problem with nested subquery

On 4 Okt., 10:11, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "MarkusSchaber" <m..._at_soloplan.de> a écrit dans le message de news:
> 40ee696d-3754-4916-849f-a848aa44e..._at_h7g2000yqn.googlegroups.com...
> Hi,
>
> I have a simple table like the following:
[snip]
> I always thought that I can refer to rows of outer tables inside
> subqueries, and did this sucessfully in other cases. Now, why does
> oracle not recognize it in this case? (We use 11g Enterprise Edition
> 11.1.0.7.0)
>
> ---------------------------------------
>
> You can refer to a column that is only one level outer.

But I need the two-level subquery here to apply the windowing function (to limit to the first row).

Do you have any idea how to solve my problem then?

Thanks,
Markus Received on Mon Oct 04 2010 - 03:25:03 CDT