title: Create table of unique values from join
body: <p>I have two tables with various addresses. One is a table of locations we already have on file, the other is new business. The idea is that I'm joining these two tables on their co-ordinates in order to show if we have a clash between the new business and the current business.</p>
  
  <p>What I have found is that in the new business we have one location that matches three locations that we already have.</p>
  
  <p>When I do my simple inner join I get back 3 records when really I want to display the 4 (1 from new, 3 from current). I have tried other joins and union as well as sub queries but with no luck. I know there is a way but just can't figure it out.</p>
  
  <pre><code>SELECT *
  FROM NewBusiness
  INNER JOIN Live L ON N.Latitude = L.Latitude AND N.Longitude = L.Longitude
  </code></pre>
  
  <p>Thanks in advance</p>