title: Joining two tables via primary key in first table sql
body: <p>I would like to join these two tables by the locationID  which is a primary key in the holiday table and select rows from the whole joined table</p>
  
  <p><img src="https://i.stack.imgur.com/GSWGY.png" alt="enter image description here"></p>
  
  <p>i would like a select all query, where you can select rows from both tables which match if you perform the result set operation. </p>
  
  <p>How would you do this?</p>