title: How to find if records match or not
body: <p>This is probably quite simple i just cant get my head round it. </p>
  
  <p>I want to display a list of the customers that have a different city listed in their billing city versus their customer city. The billing address is in a table titled invoices and the customer address is in a table titled customers. </p>
  
  <p>Is there a function that would show the ones that aren't the same? </p>
  
  <p>This is probably quite simply i just cant get my head round it.</p>
  
  <p>I want to display a list of the customers that have a different city listed in their billing city versus their customer city. The billing address is in a table titled invoices and the customer address is in a table titled customers.</p>
  
  <p>Is there a function that would show the ones that aren't the same?</p>
  
  <p>i can show the two tables together easily using a join but now i want to differentiate them</p>
  
  <pre><code>    select
      c.LastName,
      c.City,
      i.billingCity
      from Customers c
      inner join invoices i on c.customerId = i.customerId
  </code></pre>