SQL Server Joins Beginner simple join
<p>I have the following two tables:</p>

<p><strong>dbo.orders</strong>:</p>

<ul>
<li>customerid</li>
<li>orderid</li>
</ul>

<p><strong>dbo.customerprofiletbl</strong>:</p>

<ul>
<li>customerid</li>
<li>customername</li>
</ul>

<p>I am attempting to put together a join but I am failing:</p>

<pre><code>select 
    dbo.orders.customerid AS orde, 
    dbo.customerprofiletbl.customerid AS cust
from 
    dbo.customerprofiletbl
left join
    orde on cust 
</code></pre>

<p>Help?</p>