title: SQL JOIN limit results to rows where specific value does not exist
body: <p>I am joining two tables using SQL. I'm joining a table which contains charter flight information and a table which contains the crew assigned. In my results, I only want to display the rows that only have a value of "Pilot" in the the crew table and not "Copilot" or both.</p>
  
  <p><img src="https://i.stack.imgur.com/BV9FL.png" alt="enter image description here"></p>