title: Using Subqueries with joins
body: <p>I'm trying to get a list of customers that have booked country shows at our venue, however I cant seem to get the subquery and the IN filter right.</p>
  
  <pre><code>SELECT Customers.CustFirstName, Customers.CustLastName
  FROM Customers 
  WHERE Customers.CustomerID IN 
  (SELECT  Engagements.CustomerID, Musical_Styles.StyleName
  from Engagements
  inner join Entertainers
  ON engagements.EntertainerID = Entertainers.EntertainerID
  inner join Entertainer_Styles
  ON Entertainers.EntertainerID = Entertainer_Styles.EntertainerID
  INNER JOIN Musical_Styles
  ON Entertainer_Styles.StyleID = Musical_Styles.StyleID
  WHERE Musical_Styles.StyleName = 'Country')
  </code></pre>