Skip to Main Content
Forums

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!

Table alias lost on sub sub query

slokamAug 14 2013 — edited Aug 14 2013

Database version : 10.2.0.4.0

I have a query similar to following

select * from ap_invoices a

where

exists

(

select 1 from

(select invoice_id from ap_invoices b where b.invoice_id = a.invoice_id )

When I ran above, it gives an error message  ----> ORA-00904: "A"."INVOICE_ID": invalid identifier.

I need to access main query data through alias inside sub sub query. please help.

Thanks

slokam
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2013
Added on Aug 14 2013
3 comments
5,056 views