title: SQL, company has more abbo, just select only the dubble ones
body: <pre><code>  ( SELECT 
                          KltBedrijfsNaam 
                      FROM
                          [tbl relaties] 
                      WHERE
                          KltId = auoKltId
                  ) AS Naam,
                  auoNaam
  
                      FROM
                          dbo.tblAutomatischeOrdere
                          WHERE  
                  auoStatus = 'LO'
  </code></pre>
  
  <p>a Naam has more auoNaam, but there are 2 of the same auoNaam for a Naam. and i want only to show those two. i want to have Naam and de 2 auoNaam
  <a href="https://i.stack.imgur.com/lOOP0.png" rel="nofollow noreferrer">output</a> </p>