title: How to make sure all the values exist in a table in SQL SERVER
body: <p>I have a table called <code>FinanceProfilePropertyType</code>.</p>
  
  <p>It has the following columns: </p>
  
  <pre><code>    FinanceProfileId int
      FinanceProfilePropertyTypeId int(PK)
      PropertyTypeId int
  </code></pre>
  
  <p>I have another table called PropertyTypes which has a column PropertyTypeId (int).</p>
  
  <p>Lets say the table PropertyTypes contains data like this:</p>
  
  <pre><code>    PropertyTypeId:
        1
        2
        3
  </code></pre>
  
  <p>Now let's say I want to check if the following condition is satisfied: there are rows in FinanceProfilePropertyType table with FinanceProfileId = 1 and PropertyTypeId which contains all the values in PropertyTypes table. </p>
  
  <p>That is I must have all the rows in FinanceProfilePropertyType:</p>
  
  <pre><code>FinanceProfilePropertyTypeId  FinanceProfileId  PropertyTypeId
      1                              1                 1
      2                              1                 2
      3                              1                 3
  </code></pre>
  
  <p>How can I do this? </p>