title: SQL Server 2012 Joining columns from two tables into one
body: <p>I have two tables in different places</p>
  
  <p>the end result has to be</p>
  
  <pre><code>VendorName  InvoiceNumber  InvoiceTotal
  </code></pre>
  
  <p><code>VendorName</code> is in a table called <code>Vendors</code></p>
  
  <p><code>InvoiceNumber</code> and <code>InvoiceTotal</code> are in a table called <code>Invoices</code></p>
  
  <p>it needs to show all the vendors in the result even if the vendors dont have any invoices, display the largest invoice totals first DESC and sort the Vendor Names in Alphabetical order.</p>
  
  <p>I tried to Join the Invoices into my </p>
  
  <pre><code>SELECT VendorName FROM Vendors 
  </code></pre>
  
  <p>but I cannot figure out the syntax :/</p>