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!

QUESTION: HOW TO WRITE QUERY WITH MANY TO MANY RELATIONSHIPS

258794Oct 20 2005 — edited Oct 20 2005

Could someone help me out here?

I was sitting here looking at some tables ie table_name and synonyms and wondering.

If a table can belong to many synonyms and a synonym can belong to many tables how would one write a query where I would like to know which tables belong to each synonym or on the other hand which synonym belongs to what tables?

Would I try to develop an outside join for this, a corrolated query or a query with a subquery or would there be another format that would work better?

What would be the best method of attack on this?

Thanks for your thoughts on this.

al

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 17 2005

Added on Oct 20 2005

3 comments

367 views