Skip to Main Content

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!

Self relation SQL statment (Simple Query)

Amatu Allah Neveen EbrahimDec 21 2010 — edited Dec 24 2010
Hello

i just wanna know is the following : self relation SQL statment
SELECT ROWID,ACCOUNT_ID,ACCOUNT_NAME,IS_CLOSED,TYPE_ID,ACCOUNT_ID_PARENT 
FROM GL_ACCOUNTS
WHERE GL_ACCOUNTS.TYPE_ID = GL_ACCOUNTS_PARENT.TYPE_ID AND
GL_ACCOUNTS.ACCOUNT_ID_PARENT = GL_ACCOUNTS_PARENT.ACCOUNT_ID
If not pls i wanna create one

Thanks in Advance,

Regards,

Abdetu...
This post has been answered by riedelme on Dec 21 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 21 2011
Added on Dec 21 2010
9 comments
181 views