nested identifier

Giganews Newsgroups
Subject: nested identifier
Posted by:  tawright915 (tawright9…@gmail.com)
Date: 19 Sep 2006

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

Replies