title: SQL Server Select Query for company that has employee role (Owner and CEO) at the same time
body: <p>My Table Structure is shown below:</p>
  <p><img src="https://i.stack.imgur.com/DCBQb.png" alt="enter image description here" /></p>
  <p>I would like to retrieve company names and person names that working for this company and their position are (CEO and Owner), it means that person must be both (CEO and owner). I've tried so far and created below query, I can select or filter only CEO or Owner.</p>
  <pre><code>SELECT cp.id as cp_id,
  com.name,
  per.name,
  pos.position_name
  
  FROM company_person as cp 
  
  INNER JOIN company as com
  ON com.id = cp.company_id
  
  INNER JOIN person as per
  ON per.id = cp.person_id
  
  INNER JOIN position as pos
  ON pos.id = cp.position_id
  </code></pre>