title: SQL Left Join Omit Rows Found
body: <p>I have two tables that one list the transactions and one that list that are cancelled. How do you only show the transactions that are not cancelled and omit the cancelled ones?</p>
  
  <p><img src="https://i.stack.imgur.com/siQGs.png" alt="enter image description here"></p>
  
  <p>I just want to show the transactions that are not cancelled, in this case the transaction with
  transaction_id = 1.</p>