title: How to check if there are multiple values of the same attribute in the same object, SQL Server
body: <p>I have three tables: Products, PRO_FAB and Fabrics. Products table has Product_ID and Name, PRO_FAB Has PRO_FAB_ID, Product_ID and Fabric_ID, Fabrics have Fabric_ID and Name. They are related like this:</p>
  
  <pre><code>Products.Product_ID --- PRO_FAB.Product_ID &lt;-&gt; PRO_FAB.Product_ID --- Fabrics.Fabric_ID.
  </code></pre>
  
  <p>So it's basically a m:n relationship. I'm trying to make a query that will list a Product that is made out of all fabrics in the Fabrics table. I've tried using HAVING, CONTAINS and other methods, but none seems to work, or at least I don't know how to use them. I appreciate your help.</p>