title: How to join two sql tables when the common column has different names but information is the same in both tables
body: <p>Relatively new to SQL querying. I can successfully get results from a simple query that shows a customer number and a total dollars invoiced sorted highest dollar amount to lowest.  I want to also display the customer name.  The customer name, <code>[Name]</code>, is in another table along with the customer number but the column name for customer number is different, ie. <code>Table 1</code> is <code>[Bill-to Customer No_]</code> and <code>Table 2</code> is just <code>[No_]</code>.  How would I get the information from <code>Table 2</code> to display in the same row with the customer number? </p>