title: Join two tables in SQL Server
body: <p>I  have to tables </p>
  
  <p><strong>Customer</strong></p>
  
  <pre><code>CustomerID   Name        Surname
  ---------------------------------
    1          Adam        Test
    2          Robert      Test2
    3          John        Test3
  </code></pre>
  
  <p><strong>CustomerAddress</strong></p>
  
  <pre><code>CustomerAddressId  CustomerId     AddressId
  -------------------------------------------
  1                  1              1
  2                  1              2
  3                  1              3
  4                  2              6
  5                  2              7
  6                  2              8
  </code></pre>
  
  <p>I want to select <code>CustomerId</code> from these two tables. </p>
  
  <p>I wrote this query but it multiplies my records.</p>