title: join single value from one table to multiple rows table - Oracle
body: <p>I have the following tables in Oracle:</p>
  
  <pre><code>Table 1                Table 2
  AllCustomers           ProductCode   Customers
  5200000                ABC           15265
                         DEF           156890
  </code></pre>
  
  <p>In Oracle, I want to join them both, like this:</p>
  
  <pre><code>Table 3
  ProductCode   Customers   AllCustomers           
  ABC           15265       5200000
  DEF           156890      5200000
  </code></pre>
  
  <p>How can I join these tables? As you can see, they do not have a key field to join. I just need to populate a third column in the new table with the same value in it, which would be the one from AllCustomers. Thanks in advance!</p>