<div>
which database system?<br />
<br />
how are you expecting the joins to be specified anyway?<br />
<br />

</div>


which database system?

how are you expecting the joins to be specified anyway?



<div>
I am using Oracle Database.<br />
The joins will either be specified by the user or i would be picking up the primary keys of both tables and try and equate them.<br />
Thats what i am thinking of right now but can some one tell me a better solution.
</div>


I am using Oracle Database.
The joins will either be specified by the user or i would be picking up the primary keys of both tables and try and equate them.
Thats what i am thinking of right now but can some one tell me a better solution.

<div>
<div class="content wysiwyg-content">
I am developing a query builder form something similar to TOAD.<br />
When the user selects multiple columns from various tables i need to detect whether the tables can be joined or not. I want this to be done so that i can avoid a cartesian product when the final query is built and run on the server.<br />
Is there a way to detect if two tables would cause a cartesian product / not.
</div>
</div>


I am developing a query builder form something similar to TOAD.
When the user selects multiple columns from various tables i need to detect whether the tables can be joined or not. I want this to be done so that i can avoid a cartesian product when the final query is built and run on the server.
Is there a way to detect if two tables would cause a cartesian product / not.

Detecting a cartesian product

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.