How to select two columns from multiple tables and put them next to each other (no relationships or critera) in MySQL?
<p>I need a SQL statement that will allow me to take one column from one table, one column from another table, and present them side-by-side.  I've been poring through the literature on JOINs but they always seem to require an "on" clause which I'm not interested in.</p>

<p>The closest thing I've found is a "NATURAL JOIN", but that seems to output a result that gives me all the rows from column 2 for each row from column 1.  Any ideas?</p>

<p>Just for illustrative purposes, this is what I want...</p>

<pre><code>Table 1

t11
---
 0
---
 1
---
 2

Table 2

t21
---
 a
---
 b
---
 c
</code></pre>

<p>Desired result:</p>

<pre><code>Table 3 (or output of MySQL statement)

t31 | t32
--- | ---
 0  |  a
--- | ---
 1  |  b
--- | ---
 2  |  c
</code></pre>