Cross Join is creating a Loop
<p>I have three tables, I need to make a <code>CROSS JOIN</code> between them to display the IDs and names of the products and the stores that sell them, here is an example of how now</p>

<p><code>TABLE_PRODUCT</code></p>

<pre><code>ID_PRODUCT  |   NAME_PRODUCT  
1           |   Addidas Super Star
2           |   Calvin Klein BAG
</code></pre>

<p><code>TABLE_STORE</code></p>

<pre><code>ID_STORE |   NAME_STORE 
1        |   ThE 98
2        |   C&amp;A
</code></pre>

<p><code>TABLE_PROD_STOR</code></p>

<pre><code>ID_STORE  |  ID_PROD
1         |  1
2         |  2
</code></pre>

<p>And I need the result in the format:</p>

<pre><code>ID STORE  |  STORE  | ID PRODUCT |       PRODUCT      |
1         |  ThE 98 | 1          | Addidas Super Star |
2         |  C&amp;A    | 2          | CALVIN KLEIN HAT   |
</code></pre>

<p>My biggest problem is that when I do the <code>CROSS JOIN</code>, the names are repeated twice each. What is the solution?</p>