combining the results of two select statements mysql
<p>I look at all the other examples and none of them correspond to my results.</p>

<p>I have:</p>

<pre><code>select last_name, first_name from customer;
select address, district, phone from address;
</code></pre>

<p>I can't use union due to the different number of columns.  I have tried join, but I'm not sure if I'm using it properly.  Any help would be appreciated.</p>