title: SQL Query to Filter a Table using another Table
body: <p>I currently have 2 SQL tables that look like this:</p>
  <p><img src="https://i.stack.imgur.com/o7wsW.png" alt="Data Table" /></p>
  <p>and...</p>
  <p><img src="https://i.stack.imgur.com/1v3u2.png" alt="filter table" /></p>
  <p>I need to write a SELECT statement that retrieves all products from the DataTable that contain rows that match the FilterTable.</p>
  <p>So based on my example tables above, if I were to run the query, it would return the following result:</p>
  <p><img src="https://i.stack.imgur.com/3wrw1.png" alt="Result table" /></p>
  <p>I recently found a question that kind of attempts this:
  <a href="https://stackoverflow.com/questions/4764650/sql-query-where-all-records-in-a-join-match-a-condition?lq=1">SQL query where ALL records in a join match a condition?</a>
  but have been unsuccessful in implementing something similar</p>
  <p>Note - I am using Microsoft SQL Server 2008</p>