title: How to merge 2 columns with all possible combinations in SQL?
body: <p>The question sounds confusing, but just look:</p>
  
  <p>This way we can get the first column (<em>col1</em>):</p>
  
  <pre><code>select distinct maker
  from product
  </code></pre>
  
  <p>And the second column (<em>col2</em>):</p>
  
  <pre><code>select distinct type,maker
  from product
  </code></pre>
  
  <p>So now I need to get all possibly combinations from col1  and col2. Any suggestion? </p>
  
  <p>Shortly, this:</p>
  
  <pre><code>A f1
  
  B f2
  </code></pre>
  
  <p>Should become this:</p>
  
  <pre><code>A f1
  
  A f2
  
  B f1
  
  B f2
  </code></pre>
  
  <p>P.S.  This query won't return that I need.</p>
  
  <pre><code>select distinct A.maker, B.type
  from product as A
  </code></pre>