Re: nested identifier

Giganews Newsgroups
Subject: Re: nested identifier
Posted by:  fitzjarre…@cox.net (fitzjarre…@cox.net)
Date: 19 Sep 2006

tawright915 wrote:
> I'm trying this query:
>
> select distinct a.p_no, c.p_no
> from premise a, street_name b
> where a.k_str_nm = b.k_str_nm
> and exists(select '1'
>            from premise c,
>            street_name d
>            where c.ky_str_nm = d.ky_str_nm
>            and c.ky_prem_no <> a.ky_prem_no
>            and c.ky_str_nm <> a.ky_str_nm
>            and c.ad_serv_str_no = a.ad_serv_str_no);
>
> I get this error:
> SQL> @overlapping.sql
> select distinct a.p_no, c.p_no
>                              *
> ERROR at line 1:
> ORA-00904: "C"."P_NO": invalid identifier
>
> SQL>
>
> Why an I not able to see this identifier?  I thought nesting it was
> okay?
>
> Thanks
> Tom

You're not 'nesting', that query is in an EXISTS condition.  As such
you cannot use any part of its select  list in the main SELECT.

David Fitzjarrell

Replies

None

In response to

nested identifier posted by tawright915 on 19 Sep 2006