title: Correct way to use INNER JOIN statement using a bridge table
body: <p>Basically I have a table "Products" with "Product_ID" and table "Sub_Categories" with "Sub_Category_ID".</p>
  
  <p>Products that have a "Sub_Category" are linked using a bridge table, "SubC_Prod_Bridge", they are linked by ID "Products" and "Sub_Category_ID".</p>
  
  <p>Like this:</p>
  
  <pre><code>Table: Products
  Product_ID
  4
  
  Table: Sub_Categories
  Sub_Category_ID
  5
  
  Table: SubC_Prod_Bridge
  Product_ID   Sub_Category_ID
  4            5      
  </code></pre>
  
  <p>I know this question is very basic. What I am really looking for is a good reference online for JOIN statements, any recommendations are really appreciated.</p>