<div>
You need two cross-reference tables.
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
I have three table designed like following:<br />
tab1 &lt;= many-to-may =&gt; tab2<br />
tab2 &lt;= many-to-may =&gt; tab3.<br />
<br />
I know if I have many-to-many relationship between two table, I need a cross (association) table between them.<br />
but, can I have one cross table between the above described three tables?<br />
<br />
thanks.
</div>
</div>


Hi,
I have three table designed like following:
tab1 <= many-to-may => tab2
tab2 <= many-to-may => tab3.

I know if I have many-to-many relationship between two table, I need a cross (association) table between them.
but, can I have one cross table between the above described three tables?

thanks.

many to many relationship

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.